what is the maximum number of tables that can be joined ?
Answer Posted / vipin kumar verma
IN EARLIER VERSION OF DB2(DB2 V7)
15 Tables CAN BE JOINED AT A TIME
But in LATEST VERSION OF DB2(DB2 V8)
225 Tables
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Explain packages.
What is ibm db2 used for?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Is db2 a database?
How to execute stored procedures?
What are bind parameters in db2?
What are the full forms of spufi and dclgen and why are they used?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is difference between alias and synonym in db2?
Explain package in db2 and its advantages?
What is db2 stogroup?
What does runstats do in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the difference between oracle and db2?
What's The Percentage Free Space ?