Can I use a job parameter in Datastage SQL
Posted: Tue Nov 23, 2004 9:48 am
Good morning everyone,
Can I use a job parameter in Datastage SQL?
for example, if I have a job parameter named process_date, and I want to get all the data from a table TBL_Transaction before process_date, can I write a sql like this
select * from TBL_Transaction where Last_Update_Date<= #process_date#
Can I use a job parameter in Datastage SQL?
for example, if I have a job parameter named process_date, and I want to get all the data from a table TBL_Transaction before process_date, can I write a sql like this
select * from TBL_Transaction where Last_Update_Date<= #process_date#