IN EARLIER VERSION OF DB2(DB2 V7) 15 Tables CAN BE JOINED AT A TIME

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

Question Posted / vipin kumar verma

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

Please Help Members By Posting Answers For Below Questions

How do you stop a db2 database in linux?

1009

Before you give the explain statement, what are the prerogatives?

1028

How to view db2 table structure?

1014

What is iseries database?

1046

What is difference between isnull and coalesce?

1052

What is a page in db2?

1025

How to fetch the last row from the table in SQL (db2)?

1651

What is the physical storage length of timestamp data type?

1088

What is db2 stogroup?

1156

What is dclgen (declaration generator)?

1052

What is a db2 cursor?

1046

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1187

What are the various data types available in db2?

1089

How do you pull up a query which was previously saved in qmf?

1148

What are the rules for db2 programming?

1081