Passing parameter to oracle enterprise stage

Madhu1981 · Post by **Madhu1981** » Tue Apr 24, 2007 9:49 am

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

swades · Post by **swades** » Tue Apr 24, 2007 10:14 am

Madhu,
How many parameters,do you have?
And what is the SQL types for it?

DSguru2B · Post by **DSguru2B** » Tue Apr 24, 2007 10:42 am

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.