What DB2 Catalog column tell you when an index needs table
reorganized ?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
When can an insert of a new primary key value threaten referential integrity?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
where will u check for sqlcode ?
What do you need to do before you do EXPLAIN?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is nvl in db2?
What is the logical entity between plan and Package?
What is query for your birthday date should be in hours,minute and seconds format?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How to define the data items to receive the fetch items for the SQL?