Can we declare cursor in Procudere division or open the cursor in the Working s

Can we declare cursor in Procudere division or open the
cursor in the Working storage section.

Is there any particular rules in the usage of cursors lifecycle

Question Posted / srprev

1 Answers
8842 Views
Infosys, I also Faced
E-Mail Answers

Can we declare cursor in Procudere division or open the cursor in the Working storage section. ..

Answer / omkar panda

yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor

Is This Answer Correct ?

20 Yes

2 No

Post New Answer

More DB2 Interview Questions

my project is insurance management system,how to explain my work environment in interview?

2 Answers CGI, Value Labs,

What information is contained in a SYSCOPY entry?

2 Answers

is it compulsory commitment control in journal?

0 Answers TCS,

What is the difference between CS and RR isolation levels?

1 Answers

How do you insert a record with a nullable column?

2 Answers

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

Write a query to retrive partial string.

2 Answers

How to fetch the uncommited data from table ?

1 Answers JPMorgan Chase,

Is it possible using max on a char column?

0 Answers

how many bytes timestamp token occupies?

6 Answers Boss Global, Cap Gemini, TCS,

How to take backup of table in db2?

0 Answers

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

For more DB2 Interview Questions Click Here