what is the maximum number of tables that can be joined ?
- 8 Answers
- 18941 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 to resolve -818 sql code in DB2?
How connect db2 database to datastage?
The only place of VSAM KSDS in DB2 is?
What is a result table?
Which is faster delete or truncate?
Define buffer pool.
How do I delete a table in database?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What is difference between alias and synonym in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Mention data types used in db2 ?
COBOL 
