Assign Value to Job Parameter

bonds · Post by **bonds** » Wed Oct 17, 2007 1:57 am

Hi,

I have a job parameter. I need to assign value to this parameter in my Job Control Coding Window. Can I do that? If yes, how?

Thanks in advance for your help guys.

Have a good one.

saikir · Post by **saikir** » Wed Oct 17, 2007 2:03 am

Hi,

If your parnt job is accepting the parameters and you want the child job to be called with these parameters, you can do it as follows:

ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "ORACLE_DSN")

Where your job accepts the parameter ORACLE_DSN

Or you can hard code the values as below:

ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "DSN1")

You can also read the parameters from a particular file.

Sai

Sai

saikir · Post by **saikir** » Wed Oct 17, 2007 2:05 am

Hi,

If your parnt job is accepting the parameters and you want the child job to be called with these parameters, you can do it as follows:

ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "ORACLE_DSN")

Where your job accepts the parameter ORACLE_DSN

Or you can hard code the values as below:

ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "DSN1")

You can also read the parameters from a particular file.

Sai

Sai