Can a DB2 table join with a Datastage hashed file to a query

[olgc]

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,

[kcbland]

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.

[ray.wurlod]

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