Page 1 of 1

Passing parameter to oracle enterprise stage

Posted: Tue Apr 24, 2007 9:49 am
by Madhu1981
Hi,

I have a sequential file which contains all the parameters..!! Now i want to pass the parameters from the sequential file to a oracle enterprise stage in one parallel job.!!

Is there any specific function to do this..!!

Thanks in advance
Madhu

Posted: Tue Apr 24, 2007 10:14 am
by swades
Madhu,
How many parameters,do you have?
And what is the SQL types for it?

Posted: Tue Apr 24, 2007 10:42 am
by DSguru2B
Nothing specific. You have to code/design it. One way would be to read the sequential file and pass the appropriate parameter value via a small routine. This routine can be called while specifying the value of the parameter in the job activity in a sequence job.
Or you can code your custom Job Control and do the entire thing there.