Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of cursors?
- 3 Answers
- 7553 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bala
If the query inside the program retrieves only one row, there is no need to CURSOR.
If the program has to process the multiple rows that are retrieved by the query,
CURSOR is needed. Because, host variables can accommodate data from only one row at a time. By Declaring the cursor, multiple rows can be fetched one at a time and assign it to host variables for processing.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / guest
Cursors are used for providing multiple rows to process in
host language by fetching one row at a time.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / siri
it is use to retrive more than one row for an sql query return in application program....with out using cursors then it abbends with an sql code -811...
| Is This Answer Correct ? | 2 Yes | 0 No |
how can you access index
What are types of indexes?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
Which component is responsible for db2 startup and shutdown?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is view db2?
is it compulsory commitment control in journal?
What are the two types of logging in the db2 database? Explain them.
What does a deadlock mean in DB2?
How do you filter out the rows retrieved from a Db2 table ?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the cascade rule and how does it relate to deletions made with a subselect?
COBOL 
