Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20724 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 |
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How do I start db2 in windows?
How can we retrieve the total number of records in RPG & CLLE?
When do you specify the isolation level? How?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
List out the buffer pools in db2
How do you eliminate duplicate values in db2?
Once you create a view, where would information about the view be stored?
What does db2 mean?
How Plan is created while executing the query using SPUFI?
What is the latest version of ibm db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
COBOL 
