When is the results table for the query in a DECLARE CURSOR
statement created?
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 are the uses of db2 optimizer?
Is the primary key a clustered index?
What is collection in db2 bind?
What is blu acceleration in db2?
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 commit in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is release/acquire in bind?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What are catalog tables in db2?
What is db2? Explain.
Can we delete records from view?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are the various isolation levels possible?