![Embarassed :oops:](./images/smilies/icon_redface.gif)
SELECT x, x, x FROM EDW.TableName1 where UPD_DATE>= LAST_UPDATE_DATE AND UPD_DATE< #PROCESS_START_TIME#
Here PROCESS_START_TIME is a job parameter. This SQL is executed on DB2 server. Can you get the LAST_UPDATE_DATE from a hash file on the Datastage server? Or can you join a Database table with a Datastage hash file to do the query?
Thanks,