How to assign the one path of file to PROJDEF using the job parameters?

At the time to incremental loading I need to take the reusable files' path in this situation
How to assign the one path of file to PROJDEF using the job parameters?

Questions by venkata ramana   answers by venkata ramana

Showing Answers 1 - 3 of 3 Answers

From your question it seems that you have defined the file path parameter as $PROJDEF in you parallel job.

Setting a parameter to projdef :

Step 1: Go to datastage adminstrator and set a user defined variable say "File_Path" and its value. Click on ok and exit.

Step2 : Open your job and go to job parameters.there is a button in bottom right corner to add the environment variables. Click on that buton. Go to user-defined variables section and select the env variables you just defined "File_Path". Now the new env variable will appear in your parameter list

Step3: Double click on the place where we define the value for a variable. On double clicking, you will get a small window. Select "PROJDEF" from the drop down menu. Overriding/Changing values of $PROJDEF :there are two ways to assign/override the $PROJDEF

a) using Job Sequence(overriding) : In the job sequence,we use "Job activity" to call a job.When you select a job in the job activity, the list of parameters that are defined in the parallel job appears in the properties of job activity. There, you can change the path to your desired path. In this case, when the parallel job runs from the master sequence,$PROJDEF value will be overridden by the value being passed from the Job sequece.

b)Using Datastage Administrator(change) : In the datastage administrator,you can change the value of Env variable to your desired path.When the job runs,it will run for the changed value.

  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