What is scrollable cursor in db2?
Explain how can you do the explain of a dynamic sql statement?
What is concurrency in db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What information is used as input to the bind process?
What is the difference between nvl and coalesce?
What is rebind in db2?
What is correlation names?
How many buffer pools are available in db2?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
how to resolve -805. give clear explination for that
Can we install 2 different versions of Db2 on same mainframe?
What is Call attach facility? How does it work?