Answer Posted / 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 |
Post New Answer View All Answers
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Mention the various locks that are available in db2.
Define sqlca.
What is the maximum size of varchar data type in db2?
What is the default page size of buffer pools?
What do you mean by commit and rollback?
What is catalog database in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to find primary key of a table in db2?
What are the contents of a dclmgen?
What is nvl in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 bind process?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
