Automate Converting OCI 8 to OCI 9

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
suresh.narasimha
Premium Member
Premium Member
Posts: 81
Joined: Mon Nov 21, 2005 4:17 am
Location: Sydney, Australia
Contact:

Automate Converting OCI 8 to OCI 9

Post by suresh.narasimha »

Hi All

There is a need to convert all the OCI 8 stages in a project to OCI 9.

The process we followed was, exported a job in XML format and replaced the Stage Type from "ORACI8" to "ORACI9" and the code worked.

Is there a better way to convert the stages?? Like any command from Administrator to do it


Thanks,
Suresh
SURESH NARASIMHA
sachin1
Participant
Posts: 325
Joined: Wed May 30, 2007 7:42 am
Location: india

Re: Automate Converting OCI 8 to OCI 9

Post by sachin1 »

Hi Suresh,
i just have information regarding an utility OCI8TO9.B, which converts your oracle oci8 stage to oracle 9i OCI stage, but never tried it.

please check out on more details on OCI8TO9.B utility.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Exactly. IBM / Ascential provides a utility to do that for you automagically.
-craig

"You can never have too many knives" -- Logan Nine Fingers
nwexler
Participant
Posts: 1
Joined: Thu Feb 25, 2010 9:06 pm

Post by nwexler »

Right, however if you do move to 8.x the utility won't work (eCase 125155). You'll need to use the utility in 7.x then migrate.
Post Reply