"Variable 'Oconv' not defined" message in PX but n

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

"Variable 'Oconv' not defined" message in PX but n

Post by abc123 »

I moved a job from server to parallel version. In a derivation in the transformer, I get the message:

"Variable 'OConv' not defined"

during validation. Exact same app except this code is in a parallel job instead of server job.

Thanks.
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Because the Transformer stage in Parallel jobs don't support OConv and IConv functions including some other functions as well. You will need to use a BASIC Transformer stage in your parallel job in order to be able to use OConv function.
Kris

Where's the "Any" key?-Homer Simpson
thumsup9
Charter Member
Charter Member
Posts: 168
Joined: Fri Feb 18, 2005 11:29 am

Post by thumsup9 »

If you want to do it Parallel Jobs you may have to look at conversion functions like StringToTimestamp , StringToDate ..
anntaylor
Participant
Posts: 24
Joined: Tue May 10, 2005 5:17 pm

Post by anntaylor »

I would suggest not using the Basic transformer because it can cause other issues.
Post Reply