what will happen id i didnt close the cursor in the program?

[sivasaras]

Hi,

If i didn't code the close the cursor in a cobol-db2 prgoram means what it will happen?

EXEC SQL

CLOSE CURSOR

END-EXEC

[Natarajan]

When program ended, it automatically closes the cursor.

But in the case, where without closing the DB2 cursor, if you try to open the CURSOR again. OPen command will fail.
_________________
Natarajan
Chennai

[sivasaras]

My doubt is whether it will give any abend if we didnt close the cursor?

Suppose i am updating some records and i didnt close the cursor means will the records get updated or not.

Kindly let me know.

Thanks & Regards,
Siva

[Anuj Dhawan]

Well, what happend when you tried that?
_________________
Anuj


//MYWALLET EXEC PGM=SPOUSE
//SYSIN DD DSN=MYWALLET.ALL,DISP=SHR
//SYSOUT DD DUMMY

[sivasaras]

This was asked in the interview question and i didnt tried?

Regards,
Siva

[Natarajan]

There are two scenarios.

Scenario 1) If you issue COMMIT, data will be posted to ables and cursor will be clsoed automatically ( If you dont use WITH HOLD option in the cursor )
Scenarios 2) Even you dont use COMMIT and/or CLOSE CURSOR command. At the end of the program all changes will refelected into tables.

But advise is, always use COMMIT & CLOSE CURSOR, wherever it is required.
I guess,these things are part of program standards in every shop.
_________________
Natarajan
Chennai