When is the results table for the query in a DECLARE CURSOR
statement created?
Answer Posted / 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 |
Post New Answer View All Answers
what is the responsibility of the construction superintendent
What is bind package and plan in db2?
What is the role of schema in the db2 database?
How do I delete a column in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the max length of sqlca?
Is ibm db2 free?
What is meant by dclgen?
How to view db2 table structure?
How do I delete a table in database?
What r the comman abends in db2, jcl and cobol???????
What is the use of value function?
What is bind and rebind in db2?
What is the purpose of using commit?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?