what is the maximum number of tables that can be joined ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ashish kumar(einstein)
u can have as many tables as u want
| Is This Answer Correct ? | 6 Yes | 3 No |
What is explain plan in db2?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What techniques will be used to avoid deadlock??
why we go for SPUFI for creating tables or for sql queries?
Is db2 a mainframe database?
Is schema the same as database?
What is a DB2 bind?
How can we read records for specific member in CL? AND rpg?
How many types of page locks can be held in db2?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How can you get the number of rows impacted by the last executed query?