View previous topic :: View next topic |
Author |
Message |
tattva Beginner
Joined: 02 Feb 2005 Posts: 97 Topics: 36
|
Posted: Tue Nov 08, 2005 5:54 am Post subject: Replacing COBOL with SYNCSORT/INSYNC/ICETOOL |
|
|
Hi all,
we are running a Cobol program which is currently picking up the num of shares( primary KEY) from DB2 table and comparing it with the num of shares coming from file( file is sorted out on num of shares). If both match then price of share from db2 is written out to output file along with other fields from flat file.
Now my question:-
Can we achieve this just by using any 3rd party tool (SYNCSORT/INSYNC/ICETOOL)?
If Yes, Can any one please let me know how to go about achieving this?
Thanks,
Tattva |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Tue Nov 08, 2005 5:56 am Post subject: |
|
|
Quote: |
Now my question:- Can we achieve this just by using any 3rd party tool (SYNCSORT/INSYNC/ICETOOL)?
|
tattva,
Yes it is possible but why would you want to do that? Any specific reason ?
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
tattva Beginner
Joined: 02 Feb 2005 Posts: 97 Topics: 36
|
Posted: Wed Nov 09, 2005 7:57 am Post subject: |
|
|
Hi Kolusu,
that was the initail requirement. The file has millions of records and the Cycle time is more than 3 hrs. wanted to know if by using any 3rd party tools, we can reduce the cycle/CPU time .
Any help in this regard will be appreciated.
Thanks,
Kolusu |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Wed Nov 09, 2005 9:22 am Post subject: |
|
|
tattva,
cycle time of 3 hours ? I don't think the pgm should take that much cycle time to complete with the requirements you have specified. Unless you are doing something complex , the requirement seems pretty simple.
Did you run an explain on your sql statement?
Are you taking any checkpoints in between the selects ?
kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
tattva Beginner
Joined: 02 Feb 2005 Posts: 97 Topics: 36
|
Posted: Thu May 03, 2007 12:17 pm Post subject: |
|
|
Kolusu,
Could you please provid some documentation on explain.
Thanks,
Tattva |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
tattva Beginner
Joined: 02 Feb 2005 Posts: 97 Topics: 36
|
Posted: Thu May 03, 2007 1:07 pm Post subject: |
|
|
Kolusu,
Just that there is one more similar program which I need to look into.
Guess what we ( developer ) always need to do all the dirty work
One more question we have SQL explorer at our shop.. any documentation onthat ??
This thing sucks... |
|
Back to top |
|
|
|
|