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

Answer Posted / mehdee

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ibm db2 connect?

787


What is the use of with ur in db2?

840


What is cascading rollback?

891


What is db2?

954


Explain how can you do the explain of a dynamic sql statement?

890


What are the full forms of spufi and dclgen and why are they used?

879


How do you pull up a query which was previously saved in qmf?

944


What are the contents of a dclmgen?

875


define clustering index.

837


What is an instance database?

855


What is the use of value function?

881


What are the various isolation levels possible?

895


What db2 400?

941


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

987


How to create db2 table in mainframe?

894