Pre 4.2 User defined SQL behaviour in 5 version OCI Lookups

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
sankarsadasivan
Premium Member
Premium Member
Posts: 39
Joined: Tue Dec 23, 2003 3:47 am
Location: India

Pre 4.2 User defined SQL behaviour in 5 version OCI Lookups

Post by sankarsadasivan »

Hi

While using OCI lookup - user defined SQL query, there is an option
"Pre 4.2 User defined SQL behaviour".

If I dont check that option then the lookup fails with the oracle error
Illegal varriable/Number.

Can anyone please let me know what is the significance of that option and what is the correct usage.

Many thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Pre 4.2 User defined SQL behaviour in 5 version OCI Look

Post by chulett »

sankarsadasivan wrote:Can anyone please let me know what is the significance of that option and what is the correct usage.
:idea: Why not just look it up yourself? With the OCI stage open, there should be a Help button down in the lower right-hand corner. I haven't been on a 5.x server for years, but pretty sure it has always been there. Give it a read and then let us know if you still have any questions.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

In other words it has been years since Craig has used version 5 and he has no idea. Most of us are in the same boat. Please upgrade soon.
Last edited by kduke on Tue Aug 16, 2005 8:41 am, edited 1 time in total.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Click on Help.
Then click on the check box.
It should open a brief description of what's meant.
Then post that back here, so we can all know.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply