Hi,
I am using filter stage to filter out records based on a date filed.
In order to select the latest day's records i would like to use sysdate.
Can anybody please help me with the same, because it seems sysdate doesnt work with DataStage.
The condition in where goes like this:
DATE_FILED > SYSDATE
You could use the Column Generator Stage to add a date column that contains the current date (the 'Use Current Date' option in the Column Meta Data editor).
Then your Filter Stage uses a where clause the compares your input date to the new current date field.