Interested to Buy Any Domain ? << Click Here >> for more details...
When is the results table for the query in a DECLARE CURSOR
statement created?
- 5 Answers
- 9253 Views
- I also Faced
- E-Mail Answers
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 physical storage length of date data type?
How do I connect my db2 database to ibm?
What is null indicator in cobol db2?
What are the contents of a dclmgen?
Mention the definition of cobol in varchar field.
what is diffrence b/w file-aid tool and file-aid utility???
What does sqlcabc has?
What types of tables are there in the db2 database?
How many databases can be created inside an instance in db2 ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the maximum number of columns in a db2 table?
What os does db2 run on?
What is cloudant database?
What is copy pending status in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
