How to find the number of rows in a db2 table?
What is db2 command?
wht happens if we close cursor with cursor with hold option?
Describe what a storage group(STOGROUP) is?
What are the contents of a DCLGEN?
When will you chose to run RUNSTATS?
What is JOIN and different types of JOIN.
B37 abend during spufi?
How to resolve deadlock issue
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
what is dynamic cursor?gives syntax for this?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is the use of dclgen in db2?