what is the maximum number of tables that can be joined ?
Answer Posted / 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 |
Post New Answer View All Answers
What is reorg?
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
How do we specify index to include or not during bind process.
What is drop table?
What is with ur in db2?
What is the physical storage length of date data type?
What os does db2 run on?
How to check table size in db2 sap?
Explain how can you do the explain of a dynamic sql statement?
What is the use of commit in db2?
what is the responsibility of the construction superintendent
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How does cobol compile db2 program?
What is rct?