parameters setting

kavuri · Post by **kavuri** » Mon Jul 16, 2007 8:18 am

Hi experts,
I would like to desig a job which needs to take run time parameters. Can anybody give me a hint at what stage in designing I need to set the options.
for example suppose if I am reading DB2 files from DB2 server and I am having various tables need to be converted into text files through some modify stage or transformer stage. Here while designing where should I define run time variables. Can anybody give me some hints.

Thanks
Kavuri

ray.wurlod · Post by **ray.wurlod** » Mon Jul 16, 2007 7:09 pm

You should be designing your parameters well before you take up any ETL tool.
In DataStage I recommend adding the job parameters as early as possible in the job design process - maybe even before the first save, if there aren't too many of them.

sachin1 · Post by **sachin1** » Tue Jul 17, 2007 12:51 am

and these parameters what ray has said can be set values through DSSetParam.

DSguru2B · Post by **DSguru2B** » Tue Jul 17, 2007 6:13 pm

Go to the job properties, go to the job parameter's tab. You can define the job parameters there. In order to use the job parameters you need to enclose the job parameters with hashes within the stages, except the transformer stage, where you will use the job parameters as is without hashes.