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 consistency token in db2?
What is a db2 collection?
What is drop table?
Why select is not preferred in embedded sql programs?
What are catalog tables in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is db2 bind process?
What is buffer pool in the db2 database?
What is bufferpool in db2?
What language is db2 written in?
How would you find out the total number of rows in a db2 table?
What is a bind card?
What is access path in db2?
What is the connection string to connect to the DB2 Database ?
What db2 400?