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

Answer Posted / s

When OPEN CURSOR is executed

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible using max on a char column?

898


What is a system catalog table in db2?

874


How is the value function used?

868


What is database reorganization?

863


How do I optimize a query in db2?

859


What is plan in cobol db2?

828


What are the contents of dclgen?

884


What is the syntax for creating a table in the db2 database?

910


What is the role of the data page in the db2 database?

802


Mention data types used in db2 ?

906


How do you simulate the explain of an embedded sql statement in spufi/qmf?

873


What is cobol db2?

767


Name the various locking levels available?

859


What is the maximum number of columns in a db2 table?

1025


What os does db2 run on?

777