View previous topic :: View next topic
|
Author |
Message |
rambabu Currently Banned New User
Joined: 18 Apr 2005 Posts: 67
|
|
|
|
11. Db2 table having 10,000 Records but one record error occurred how could I find that error?
2.how to improve the efficiency of Ur db2 program?
3.suppose one db2 program for execution purpose it can take 13 days but I want to execute only 2 day how to improve efficiency of Ur program?
4.In Cobol and cics program how it can compile and link edit.
5.restart logic where in Ur db2 program can be written?
6.in Cobol pgm A Pgm B and Pgm C (pgm b and c are subprograms) here pgm A can call Pgm B and Pgm C in single call statement how can it call plz write code for that.... It contains some condition that is IF age > 45?then how can u do?.
7.In expeditor list option useS?? |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi rambabu,
Quote: |
11. Db2 table having 10,000 Records but one record error occurred how could I find that error? |
It's little bit dificult only and it depends on the query ie., for example if v r having a range of values in a column and v can write a query for checking if any row is out of that range.. like that v can check it of.. and the error occured row is easily retrived only by the developer of the table only.
Quote: |
2.how to improve the efficiency of Ur db2 program? |
There are many possible ways. It purely depends on the query which is coded on the table to retrive the records. For example the time efficiend query if u need to use only two or three rows u should make a query with that condition alone instead of using select all query. like that u can make ur code efficient.
Quote: |
3.suppose one db2 program for execution purpose it can take 13 days but I want to execute only 2 day how to improve efficiency of Ur program? |
Since ur program takes 13 days purely then u can reduce to some 10 or 11 days i dont think u can suddenly reduce it to 2 days.. if so then u should consider my above solution ie., simple and less timing query...logic will help u to do so.. |
|
Back to top |
|
|
rambabu Currently Banned New User
Joined: 18 Apr 2005 Posts: 67
|
|
|
|
any one give me the answers in the 4,5,6,7 questions |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi rambabu,
Quote: |
4.In Cobol and cics program how it can compile and link edit. |
I think the JCL which u r using is enough...
Quote: |
5.restart logic where in Ur db2 program can be written? |
ibmmainframes.com/viewtopic.php?t=7691&highlight=restart+db2
View the above link for restart logic..
Remaining let any one help u.... i m sorry...i was not clear with the remaining queries.... |
|
Back to top |
|
|
|