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,
Can a DB2 table join with a Datastage hashed file to a query
Moderators: chulett, rschirm, roy
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: