How do we use Job Parameters in datastage jobs.

I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can somebody explain me in detail with an example. I wud seriously appreciate your help. Thanks Guyz.

Questions by Geekmania

Showing Answers 1 - 6 of 6 Answers

Fanguna

  • Nov 19th, 2007
 

There is an icon to go to Job parameters in the tool bar. Or you can press Ctrl+J to enter into Job Parameters dialog box. Once you enter, give a parameter name and corresponding default value for it. This helps to enter the value, when you run the job. Its not necessary always to open the job to change the parameter value. Also when the job runs through script, its just enough to give the parameter value in the command line of script.
Else you have to change the value in the job,compile and then run in the script. So its easy for the users to handle the jobs using parameters.

  Was this answer useful?  Yes

Behrouz

  • Jan 27th, 2009
 

For example I create a parameter for my hashfile folder like it :


Name: $pHashdir, type:string,def.value:” C:DataStageInput DATAHash”


and when I use my hash file in path file name i use just this parameter $pHashdir 

and when you run your job, datastage replace this one C:DataStageInput DATAHash

you can use it for the username, sourcename, password of your DB 


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions