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
Moderators: chulett, rschirm, roy
Yes, you can use parameters in your SQL. The only thing I think you might need are ticks around your date. We use SQL Server and the dates are required to be enclosed in ticks.
Code: Select all
select * from TBL_Transaction where Last_Update_Date<= '#process_date#'
Keith
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA