Assign value to a variable in a parameter file
Posted: Fri May 13, 2005 5:48 am
Hi DS users,
I want to get max value from my last run sequential file for a field and i would like to assign the same to a variable in a parameter file so that when i run the job the nexttime, i will use that value in the source query where clause
eg) where batch_id > #batchid#
Assume i have loaded batchid 1,2,3 and nexttime when i run the job it should pick up 3 and i will extract records >3.
If any Datastage and Unix gurus are there let me know how to assign the same to a variable in a parameter file and use the same.
(The operating system is UNIX)
cheers,
gops
I want to get max value from my last run sequential file for a field and i would like to assign the same to a variable in a parameter file so that when i run the job the nexttime, i will use that value in the source query where clause
eg) where batch_id > #batchid#
Assume i have loaded batchid 1,2,3 and nexttime when i run the job it should pick up 3 and i will extract records >3.
If any Datastage and Unix gurus are there let me know how to assign the same to a variable in a parameter file and use the same.
(The operating system is UNIX)
cheers,
gops