Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20385 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 dbrm? When it will be created?
What is buffrpool? Where we use it ?
Why cursor is used in db2?
How can you do the explain of a dynamic sql statement?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is the default page size of buffer pools?
Is Cursor exicutable ?
How does DB2 use multiple table indexes?
How many buffer pools are there in DB2?
What is host variable?
Request to database but database is not available so what is was abend is raised?
COBOL 
