what is the maximum number of tables that can be joined ?
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 |
Which components manage deadlocks in db2?
What is a cursor?
Which catalog tables contain authorization information?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What does the sqlcode of -818 pertain to?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is null indicator in cobol db2?
What are the contents of a DCLGEN?
What is a NULL value? What are the pros and cons of using NULLS?
Do we need cursor for Count(*)?
How to resolve -504 sql code in DB2?
Are views updatable ?