DSXchange

Can a DB2 table join with a Datastage hashed file to do a query? Such as, the SQL statement is as the following:

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,

Absolutely not.

If you have need to use job parameters, then fetch them from hash file and put into into parameters using custom job control or Sequencer logic.

I don't see why there's any need for a hashed file at all, if the value already exists as a job parameter.