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

What is null in db2?

972

What is package in cobol db2?

1095

Can we insert update delete in view?

927

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

1610

Explain the function of data manager.

1011

What is dbrm? What it contains?

1131

What does runstats do in db2?

1052

What is catalog database in db2?

1123

What is db2 and what is the use of db2 optimizer?

1014

What are the rules for db2 programming?

1058

Which component is responsible for processing sql statements and selecting access paths?

1097

How many databases can be created inside an instance in db2 ?

998

What is dbrm in db2 database?

1064

Why do we bind in db2?

1169

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

1030