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 universal database?
Explain about rct.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is collection in db2 bind?
How to compare data between two tables in db2?
How do you pull up a query which was previously saved in qmf?
What is bind plan?
Explain in detail about buffer manager and its functionalities?
Mention data types used in db2 ?
Is db2 free?
How to find the maximum value in a column in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is copy pending and check pending in db2?
What is the difference between spufi and qmf?
What is a db2 table?