Name some fields from SQLCA
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What do you do to keep the cursor from closing after a commit?
What is the maximum No of rows per page?
What is the picture clause of null indicator variable?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
how can we find nth max salary from A table
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Give some example of statistics collected during RUNSTATS?
What's The Percentage Free Space ?
What is meant by AUTO COMMIT?
What os does db2 run on?