What is a cursor and what is its function?
Answers were Sorted based on User's Feedback
Answer / s
Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.
| Is This Answer Correct ? | 2 Yes | 0 No |
Where is the access path logic created by the DB2 Optimizer stored?
Explain the contents that are a part of dclgen.
what is the difference between declaring the cursor in WS section and Procedure division?
i have a db2 variable how do u declare tht into working storage section ?
How do we specify index to include or not during bind process.
How do you select a row using indexes in db2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is dclgen in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What action db2 takes when a program aborts in the middle of a transaction?
What will the FREE command do to a plan?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?