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
- 9202 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
Name the various locking levels available?
What is a cursor in programming?
What is explain plan in db2?
What is with ur in db2?
How many types of page locks can be held in db2?
Is db2 a mainframe?
Where can you declare a cursor in a cobol-db2 program?
What is node in db2?
How does db2 sample database connect?
Can there be more than one cursor open for any program?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are catalog tables in db2?
How is the value function used?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the result of open cursor statement?
