What kind of database is db2?
What is the use of runstats in db2?
wht is d/f between union and joins ?
What is runstats and reorg in db2?
wht r the requirements for writing a cobol-db2 pgm ?
Can a array declared with an index be displayed(readable format) in spool?
Explain the function of data manager.
Explain the EXPLAIN statement?
how will you retrieve first record in table
Define check constraint.
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
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 view db2?