Interested to Buy Any Domain ? << Click Here >> for more details...
Can we declare cursor in Procudere division or open the
cursor in the Working storage section.
Is there any particular rules in the usage of cursors lifecycle
- 1 Answers
- 8939 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / omkar panda
yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor
| Is This Answer Correct ? | 20 Yes | 2 No |
Why select is not preferred in embedded sql programs?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is cursor stability?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What are common abends
Define data page.
how can we retrieve the 100 records of the file ?
Write a query to retrive partial string.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Write a query to extract first 5 characters of a name in the column Stud_Name?
How many types of page locks can be held in db2?
COBOL 
