what is the maximum number of tables that can be joined ?
- 8 Answers
- 17755 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 we will do null data selection in cobol-db2 program
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Where are plans stored?
How to run db2 command in windows?
How to create db2 table in mainframe?
What are the abend codes occour in ur latest PROJECT in DB2
What is the difference between nvl and coalesce?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
i want to maintain uniqueness on pdf without make lf??????????
Mention the different locking levels that are available in db2.
What is the database descriptor?
Mention some fields that are a part of sqlca.
COBOL 
