job parameters in job control code

hiltsmi · Post by **hiltsmi** » Sat Aug 13, 2005 10:27 am

I have a job parameter called input_file.

In my job control code I try to open the file with the following code

OPENSEQ "#input_file#" TO FILE THEN

The job control parameter has a default value.

I added some logging statements to see what is happening and it appears that the job parameter is not being expanded.

When are job parameters evaluated by datastage?
Can job parameters be used in the before-job and after-job subroutines?

ArndW · Post by **ArndW** » Sat Aug 13, 2005 10:30 am

The syntax in the Job Control code should read:

Code: Select all

OPENSEQ input_file TO FILE THEN {...}

You do not need to specify the # hash marks in Job Control code to use parameters, and the quotes you used are also extraneous.

Happy coding...

ray.wurlod · Post by **ray.wurlod** » Sat Aug 13, 2005 6:18 pm

If you want to make it pellucid, specify DSGetParamInfo() explicitly.

Code: Select all

InputFileName = DSGetParamInfo(DSJ.ME, "input_file", DSJ.PARAMVALUE)

OpenSeq InputFileName To FileVariable...

You should always specify a LOCKED clause with OpenSeq. Since OpenSeq sets an update lock, you need to be certain that the lock is not already owned by some other process.