Answer Posted / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How does a cursor work?
Define check constraint.
Explain in brief how does db2 determine what lock-size to use?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
List some fields from sqlca?
What does runstats do in db2?
What is database alias db2?
On which levels locks can be applied?
What parameters are used to control the free space in DB2?
What is dbrm? When it will be created?
Why do chiropractors use drop table?
List down the data types in the db2 database.
Explain what are the various isolation levels possible?
What is the use of dclgen in db2?
Which components manage deadlocks in db2?