Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20310 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 |
What is a db2 package?
What are the isolation levels possible ?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Can you tell me how can you find out the # of rows updated after an update statement?
What is a result table?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What are the Isolation levels possible ?
What are union and union all?
What is dclgen in db2?
Give the name of some fields form sqlca.
Where is the output of EXPLAIN stored?
COBOL 
