Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20409 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 |
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is dclgen in db2?
What are bind parameters in db2?
How do we specify index to include or not during bind process.
What is the difference between IN subselects and EXISTS subselect?
How Plan is created while executing the query using SPUFI?
How is the value function used?
What is the difference between primary key & unique index ?
What are simple, segmented and partitioned table spaces ?
Why db2 is called db2?
How many sub queries can you combine together ?
What is deadlock?
COBOL 
