DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by commit and rollback?
What is the difference between dbm cfg and db cfg file in db2 ?
What does the REORG Utility do?
What are the functions of Bind?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
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 reorg in DB2
what is static sql? what is dynamic sql? Give me details
What's the maximum number of volumes that can be added to a STOGROUP?
What is image copy?
How would you find out the total number of rows in a db2 table?