What is DYNSLT keyword? How do you perform selection using DYNSLT
Give the COBOL definition of a VARCHAR field.
What techniques will be used to avoid deadlock??
Which component is used to execute the sql statements?
What is a db2 package?
What DB2 Catalog column tell you when an index needs table reorganized ?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is COPY PENDING status?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
what is plan? is plan executable or package?
what is consistency token
How will you return the number of records in table?
What action db2 takes when a program aborts in the middle of a transaction?