What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?
Answer Posted / mainframe virumbi
The answers given above is correct only. Adding those, we
cant execute sql statements other than select, after commit
is encountered.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is innodb buffer pool?
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 is meant by union and union all?
Mention data types used in db2 ?
What is db2 plan table?
What is meant by dclgen?
What is isolation level in db2?
Define declaration generator (dclgen).
What is the maximum size of a char data type in db2?
What type of database is db2?
Explain what are the various isolation levels possible?
What is the physical storage length of the data types date, time, and timestamp?
What are foreign keys in db2?
List some fields from sqlca?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.