DSXchange

Hi,
We have a requirement where we need to create a DS Job to extract data from Sequential file and load to Target (we need to create multiple target tables for different sequential files dynamically).

The DS job is executed from script and also the input file name is passed as paramter to the script.

Now the question is how can i access the parameter(filename which is passed from the unix script) in the Datstage job. I need to load that value in target table.

Also is it possible to create a table(from DS job) using the data coming from a column rather than the parameter name.

Please help me on this.....

Regards,
Balu

you can create the routine and read the sequential file

The first question is easily answered, yes. Use shell variables (such as $1, $2) to access the command line arguments and use these in the -param options of the dsjob command used to request the job run ( for example -param jpEndDate=$1).

The meaning of your question about creating a table is not clear. What - precisely - do you want to do here? That question probably warrants a separate thread, as it seems to have little to do with the subject of this one.

But i need the sequential file name. How can i get that?

I got the solution. Thanks vishal and ray...

Mark the topic as resolved