Hi All,
I have a scenario where I need to extract the data from a Mainframe DB2 table(Table A) based on the condition given below.
I have another table from where I need to take max(date)----Select max(date) from table B.
Now, i need to pull the data from Table A based on the condition
A.(Date) > max(B.date)
Pls note that one table is in Mainframe DB2 & the other one is in DB2.
Thanks for your help.
Freddie.
Delta Data from DB2 Stage
Moderators: chulett, rschirm, roy
You cannot do this directly in one job using DB2 stages. It is better to have a sequence which calls first one job to get the max value, then passes that value to the second job which then performs the SQL.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>