1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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


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

cobol-db2 runjcl please?

2 Answers   DELL,

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

What is -904 sql code? How to resolve it?

3 Answers  

What is the purpose of the WHENEVER statement?

1 Answers  

What are the disadvantages of PAGE level lock?

3 Answers  




what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

What happens in bind step in a db2 program?

0 Answers  

what is difference between Plan and Package

1 Answers   Syntel,

difference between group clause and order clause

1 Answers  

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

What is an alias?

3 Answers  

For more DB2 Interview Questions Click Here
Categories