Using the output of an Oracle Stored Function

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
Su
Participant
Posts: 13
Joined: Thu Sep 26, 2002 7:16 am

Using the output of an Oracle Stored Function

Post by Su »

I need to use an oracle packaged function to get the value of a field to be used in a transform . The input to the transform is a sequential file and the output is an OCI8 stage.
The function will take 2 parameters (2 fields from the sequential file) and return a number which i need to populate a particular column in the output stage.
How can this be done? Can i use an OCI8 stage?
Any help is greatly appreciated.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”