View previous topic :: View next topic
|
Author |
Message |
nagalakshmi
New User
Joined: 23 Feb 2005 Posts: 7
|
|
|
|
Hi,
1. Suppose two programmers coded Cobol-DB2 Pgms for the same request. How to identify which programs is more efficient than other?
2. An Embedded SQL Statement is erroneous in a Cobol-DB2 pgm and execution is unsuccessful. How to identify the corresponding SQL statment and the Field which caused this error and where to locate the value of this field.
Thanks
Lakshmi |
|
Back to top |
|
|
mainframenaidu
New User
Joined: 02 Mar 2005 Posts: 6
|
|
|
|
Hi,
1. which pgm using the SQL query effectively, means like using the cursors. Let me know if anything else.
2. if u want to know the status of each command, put Display statement after each sql statement and dispaly the error message
thanks,
Naidu |
|
Back to top |
|
|
ovreddy
Active User
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
|
|
|
|
Hi Lakshmi,
1 Ans: COBOL+DB2 program effisiency depends on the number of DB2 calls and Query complexity. The best program should process every thing in COBOL and access DB2 very less number of times even using optimized SQL statements.
2 Ans: I think you know SQLCODE. Display SQLCODE after executing each SQL statement so that you will know where program will fail. Go to spool and find out the SQLCODE and proper message. I think it will work for you.
Bye,
Reddy. |
|
Back to top |
|
|
|