When is the results table for the query in a DECLARE CURSOR
statement created?

Answers were Sorted based on User's Feedback



When is the results table for the query in a DECLARE CURSOR statement created?..

Answer / s

When OPEN CURSOR is executed

Is This Answer Correct ?    4 Yes 1 No

When is the results table for the query in a DECLARE CURSOR statement created?..

Answer / biswamoy

You can Declare Cursor either in Working-storage section or
in Procedure division. It is not executable

OPEN CURSOR is executable ( here it creates Result), Fetch
rows within loop then close cursor.

Is This Answer Correct ?    0 Yes 0 No

When is the results table for the query in a DECLARE CURSOR statement created?..

Answer / shailendra

cursor
declare cursor : it is not exectable statement it take
place in working storage section,it just keep the cursor
on that place where the condition is satisfied which is
define in the quary.


executable statement define in procedure division:

1> open cursor : it define now which cursor open to retrive
data, we can define many cursor at a time.
2> fetch cursor:this statement fetch the record which is
satisfy the condition
3> close cursor : it close the cursor

now if we want to fetch the same record again then it must
to go through open cursor statement again.

Is This Answer Correct ?    2 Yes 3 No

When is the results table for the query in a DECLARE CURSOR statement created?..

Answer / mani

the first one is correct i.e. when the open cursor statement
gets executed, the results table is created for the query in
declare cursor statement.

after that when fetch is done it is actually retrieved one
by one from the results table.

Is This Answer Correct ?    1 Yes 2 No

When is the results table for the query in a DECLARE CURSOR statement created?..

Answer / mehdee

It is not OPEN CURSOR is executed, it is the 1st FETCH.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

How can you classify the locks in db2?

0 Answers  


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,






Define db2 and its databases?

0 Answers  


What does db2 stand for?

0 Answers  


Are view updateable?

0 Answers  


What is the maximum size of a char data type in db2?

0 Answers  


Mention the various locks that are available in db2.

0 Answers  


what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  


What is bind and rebind in db2?

0 Answers  


Categories