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
- 9015 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailendra
cursor
declare cursor : it is not exectable statement it take
place in working storage section,it just keep the cursor
on that place where the condition is satisfied which is
define in the quary.
executable statement define in procedure division:
1> open cursor : it define now which cursor open to retrive
data, we can define many cursor at a time.
2> fetch cursor:this statement fetch the record which is
satisfy the condition
3> close cursor : it close the cursor
now if we want to fetch the same record again then it must
to go through open cursor statement again.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How does cobol compile db2 program?
Explain the contention situations caused by locks?
What is release/acquire in bind?
Explain about rct in db2?
What is db2 stogroup?
What is buffer pool in the db2 database?
What is the meaning concurrency in the db2 database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is query_cache_limit?
What is a plan and package in db2?
How do I delete a column in db2?
What is dbrm in db2 database?
What's The Percentage Free Space ?
How do you find the maximum value in a column in db2?
What are the two types of logging in the db2 database? Explain them.
