How and when does the db2 enforces the unique key?
Explain what a plan is?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a Database Request Module(DBRM)?
In terms of DB2 indexing, what is the root page?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
Normalization in DB2 – first normal form, second normal form
How Plan is created while executing the query using SPUFI?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is an access path?