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
- 9201 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / biswamoy
You can Declare Cursor either in Working-storage section or
in Procedure division. It is not executable
OPEN CURSOR is executable ( here it creates Result), Fetch
rows within loop then close cursor.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / mani
the first one is correct i.e. when the open cursor statement
gets executed, the results table is created for the query in
declare cursor statement.
after that when fetch is done it is actually retrieved one
by one from the results table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / mehdee
It is not OPEN CURSOR is executed, it is the 1st FETCH.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to create a table using embedded sql?
What does the REORG Utility do?
What is the latest version of ibm db2?
Explain the function done by data manager?
How to connect to db2 database from windows command line?
What happens to the PLAN if index used by it is dropped?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
How to define the a field which accepts value till 99999.99 in db2
What is the difference between cursor and select statement?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
Why do we bind in db2?
COBOL 
