suresh

• Nov 14th, 2005

 

no of tables that can be joined in a single query are 15

balajikarnati

 Profile Answers by balajikarnati 

• Nov 22nd, 2005

 

Maximum number of columns in a table -->

256

 Maximum lenght of a row in a table -- > 64KB

Culver_lake

 Profile Answers by Culver_lake 

• Mar 18th, 2006

 

Sorry guys but those are not DB2 metrics.

In DB2 Version 8 the max length of a row is 32K not 64K.

The max number of tables in a join is 225 (for many releases 15 tables was the max but not any more, version 8 is a beast of a release, the biggest ever in db2 history)

and the max number of columns in a table is 750 (it's been 750 since Version 3 in 1991 prior to that it was 300).

I'm afraid you have DB2 mixed up with something else.

Culver_lake

 Profile Answers by Culver_lake 

• Mar 18th, 2006

 

To answer the original question, for many releases only one column could appear in the result table of a subquery.  As of Version 7 of DB2 the result of a subquery is equivalent to a fullselect which means that 750 columns can appear.