Using SQL queries in job parameters

[RAJARP]

Can I use SQL queries as values of job parameters directly?? If not, how can i use SQL queries to fetch the values of records in the database.

Can you plz tel me how to use procedures/routines to do the same. I actually want to fetch the max(id) from one table and use it as the value to populate the remaining records into another table.

Thanks

[phanipriya]

Hi

SQL Queries can be passed as values to the job parameters directly and even the other job parameters can be passed as values to the conditions in the query using #<job-parameter name>#

[kduke]

You usuaully need to land the value into a sequential file then read that value in job control or a routine to feed it into a parameter.

Job Sequence

JobA Select Max(id) from whatever => SeqFileA
|
V
RoutineA Read Value set Arg1 = SeqFileA.value
|
V
JobB (Set parameter = RoutineA.Arg1

[stefanfrost1]

Also, depending on the database engine your using you may need to slash (\) any special character. For instance:

Select col1 from table1 where datecol = '2007-12-12'

May need to be converted into

Select col1 from table1 where datecol = \'2007-12-12\'