What is the difference between bind and rebind in db2?
What is runstats utility in db2?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What are iseries servers?
What is buffer pool?
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 a db2 cursor?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is correlation names?
Give some example of statistics collected during RUNSTATS?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
How to create a table using embedded sql?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....