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
- 9094 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
What is scrollable cursor in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Why do we use cursor?
what is a corelated subquerry?
What is the physical storage length of the data types date, time, and timestamp?
What is blu acceleration in db2?
What is the meaning concurrency in the db2 database?
What is a buffer in memory?
How many databases are there?
What is null indicator in cobol db2?
What is the syntax for FETCH in DB2 ?
How do I import data from excel to db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is role in db2?
