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


Please Help Members By Posting Answers For Below Questions

How do you find the maximum value in a column in db2?

650


My sql statement select avg(salary) from emp yields inaccurate results. Why?

643


Who uses db2?

576


what is a corelated subquerry?

658


is it compulsory commitment control in journal?

2013






what is the role of the cursor in db2?

643


What is the use of commit in db2?

634


What is rct?

751


What is db2? Explain.

606


What is syscat in db2?

580


What is the maximum size of a char data type in db2?

588


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

660


What is bind and rebind in db2?

650


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

624


What are the contents of dclgen?

659