I have a Main Program which is calling Sub-Program which is
a DB2 pgm. What will happen if I am not closing the cursor
used in the Sub-program? Please advise..
Answers were Sorted based on User's Feedback
Answer / swati
If Sub-Program executtion is terminated,cursor is
automatically closed.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / subhani
DEAR DUDE ABIRAMI DONT GIVE WRONG ANSWERS PLEASE.... SO MANY
PERSONS PREPARE FOR INTERVIEW PLEASE I REQUEST TO U........
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abirami
If you do not close the cursor it might give warnign
message, But it will not fail, When you try to open next
time it will give error that cursor is already opened, and
you are tryign to open the same
| Is This Answer Correct ? | 0 Yes | 13 No |
How will you find the currepted records in a file
COMPUTE X = A * B - C * D and COMPUTE X = (A * B) - (C * D) (a) Are not the same (b) Are same (c) Syntactically wrong (d) Will yield a run time error
What is the LINKAGE SECTION used for?
What are different file OPEN modes available in COBOL?
what is the difference between COBOL2 AND COBOL390?
How to execute a set of JCL statements from a COBOL program?
what are the utilities for load and unload the DB2 tables
) How do you access the migrate the data from production region to development region
How to solve SOC7. I have the cobol coded as below 01 A PIC 9(4). 01 AIN REDEFINES A. 05 AIN1 PIC S9(4) 01 B PIC 9(4)V99. 01 BIN REDEFINES B. 05 BIN1 PIC S9(4)V99. PROCEDURE DIVISION. START-PARA. INITIALIZE A AIN B BIN. ACCEPT A B. DISPLAY 'VALUE OF A=' A. DISPLAY 'VALUE OF B=' B. DISPLAY 'VALUE OF BIN1=' BIN1. DISPLAY 'VALUE OF AIN1=' AIN1. COMPUTE AIN1 = BIN1 - AIN1. DISPLAY 'VALUE OF AIN1=' AIN1. When i'm executing this code i'm getting SOC7 for A = 12 & B=34. Can someone explain SDSF OUTPUT DISPLAY TCOM058R JOB05458 DSID 102 LINE 0 COLUMNS 02- 81 COMMAND INPUT ===> SCROLL ===> CSR ********************************* TOP OF DATA ********************************** VALUE OF A=12 VALUE OF B=34 VALUE OF BIN1=34 VALUE OF AIN1=12 CEE3207S The system detected a data exception (System Completion Code=0C7). From compile unit PROG1 at entry point PROG1 at statement 29 at compile +000004CE at address 00007ECE. Please address how to solve this issue Thanks in advance.
Can a Search can be done on a table with or without Index?
How do u initialize an array?
where do we use dyanamic call ? and where do we use static call pls give any example pls ?