Can you use a select query in a loop to fetch multiple rows?
If so what is the advantage of using a cursor?
Answers were Sorted based on User's Feedback
No. In cobol-db2 program, the result of single select should be only one row.
For multi row fetch we must use cursor, else program will abend with -811 sql code.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / satheesh reddi
no...for that we are using cursors. due to cursors we can retrieve or fetch number of rows at a time from the table
Is This Answer Correct ? | 0 Yes | 0 No |
Describe what a storage group(STOGROUP) is?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the physical storage length of time data type?
wt is view ? wht r the restrictions for view ?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
Return code 100 means?
Explain correlated sub-queries.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do you check for a null value in a db2 column?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What r the comman abends in db2, jcl and cobol???????
What is buffer pool?