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
- 9441 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
Who uses db2?
How and when does the db2 enforces the unique key?
How many databases can be created inside an instance in db2 ?
How to restart a DB2 program?
What are the contents of dclgen?
What is the use of db2 optimizer?
What is the purpose of using commit?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the use of runstats in db2?
What's The Percentage Free Space ?
What r the comman abends in db2, jcl and cobol???????
What do you mean by between and in? Is between inclusive of specified range values?
How do I import a csv file into db2?
Which isolation level provides maximum concurrency?
What is iseries database?
