What is difference between defining the DB2 cursor in working storage section and in procedure division? How does it affects to Cobol-DB2 program if the cursor is defined in working storage section and if defined in procedure section.

Interview Candidate
Apr 25th, 2007
2
7027

Showing Answers 1 - 2 of 2 Answers

Raghuram Balakrishnan
Profile Answers by Raghuram Balakrishnan

Jul 19th, 2007

There is no difference in declaring a cursor in working storage or procedure division. The only constraint with declaring a cursor is that it should be done before any OPEN CURSOR statement.

sethy.pradeep
Profile Answers by sethy.pradeep

Nov 18th, 2008

It does not make any difference that you are defining cursor in working storage section or in procedure division. You can define it in both places. If you are defining a cursor in procedure division it doesn't affects at all of your Cobol/db2 program.
Regards,
Pradeep