what is the maximum number of tables that can be joined ?

Answer Posted / jitinder

IN DB2 V7
You can have the maximum upto 15 Tables

But in DB2 V8
You can have the maximum upto 225 Tables

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between oracle and db2?

578


Why do we bind in db2?

615


Where can you declare a cursor in a cobol-db2 program?

598


Explain about rct.

639


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

569






Comment whether the cursor is closed during commit or not.

660


What is sqlca?

608


What is bind package and plan in db2?

588


What is a db2 package?

595


What is db2 look?

565


What is dbrm in db2 database?

579


Explain how can you do the explain of a dynamic sql statement?

645


How will you return the number of records in table?

509


What is blu acceleration in db2?

597


Can we update view in db2?

551