What is difference between alias and synonym in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is the database descriptor?
Name the lockable units in DB2?
Describe the elements of the SELECT query syntax?
What is a clustering index?
What is subquery ?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is the use of runstats in db2?
Q3. How will you fetch duplicate values from a DB2 table?
What is REORG? When is it used?
What is a db2 collection?