How to fetch the last row from the table in SQL (db2)?
What os does db2 run on?
What is a DB2 bind?
Mention and explain the contention situations caused by locks?
difference between group clause and order clause
What is schema in db2?
How to know the primary key of a table without defining the primary key in the table?
Explain about rct.
What is the maximum size of varchar data type in db2?
What is meant by index cardinality?
what is the input to PLAN? what is the input to DBRM?
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 is dclgen (declaration generator)?