Reading the data from DB ( 2 file systems)
Posted: Thu Aug 12, 2010 7:00 am
I have a Scenario as follows,
*) I need to take Max(TimeStamp) from DB2 table
*) Based on this Max(TimeStamp) value, i need to extract (Select *) from a DB2 Mainframe table.
I tried doing it thru 2 jobs & calling it through a sequencer.(One execute command activity also)
My first job will take MaX(Timestamp) & write it to a file ( Here the conversion of Timestamp to String is done)
In the sequencer, I am using an execute command Activity that will read the file.A script will output the timestamp value.
In the 3rd job activity. the output of the Exec COmmand will be passed will be passed as a parameter (max(Date)) to the Select clause.
The issue is the output of the command activity is not getting passed to this parameter.
Can you pls confirm whether the logic I am following is correct?
Is there any better ways of doing this ?
Thanks for your help.
Freddie
*) I need to take Max(TimeStamp) from DB2 table
*) Based on this Max(TimeStamp) value, i need to extract (Select *) from a DB2 Mainframe table.
I tried doing it thru 2 jobs & calling it through a sequencer.(One execute command activity also)
My first job will take MaX(Timestamp) & write it to a file ( Here the conversion of Timestamp to String is done)
In the sequencer, I am using an execute command Activity that will read the file.A script will output the timestamp value.
In the 3rd job activity. the output of the Exec COmmand will be passed will be passed as a parameter (max(Date)) to the Select clause.
The issue is the output of the command activity is not getting passed to this parameter.
Can you pls confirm whether the logic I am following is correct?
Is there any better ways of doing this ?
Thanks for your help.
Freddie