To pass job parameter in a SQL file

dxk9 · Post by **dxk9** » Wed Jan 18, 2012 3:03 am

Hi,

I want to call the job parameter (age) in the where clause of the SQL file called in the DB2 stage.

The clause used in the sql file is :

'where Cust_Age = '#age#'

But its not recognizing the parameter.

Kindly help.

Regards,
dxk9

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2012 3:06 am

Why would you ever expect it to work? The scope of a job parameter is the job itself. The SQL file is external to the job.

dxk9 · Post by **dxk9** » Wed Jan 18, 2012 3:08 am

Thanks.

Can you plz let me know which is the best way to do it ?

Regards,
dxk9

chulett · Post by **chulett** » Wed Jan 18, 2012 7:50 am

If you insist on using a SQL file, you would need to translate the parameter and build the file with the actual value in it. Each time.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2012 2:47 pm

In a sequence read the value then pass it to a job that includes parameterized SQL within the job design itself. Or have the sequence generate the entire SQL statement and pass that to the job as a parameter.