Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
- 1 Answers
- 5968 Views
- UST, I also Faced
- E-Mail Answers
Answer / hitendra valluri
As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you use max on a char column?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
How to retrieve rows from a db2 table in embedded sql?
what happend with out using Commit,when closing cursor and program?
What is the max length of sqlca?
When reorg is used?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is null in db2?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
what is + sign and -ve sign for sql code ?
How to fetch the uncommited data from table ?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
COBOL 
