what is the maximum number of tables that can be joined ?
Answer Posted / 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 |
Post New Answer View All Answers
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 are the benefits of using the db2 database?
what is utility for parm lib
What is host variable?
What happens in bind step in a db2 program?
What is the role of schema in the db2 database?
What is buffer pool and list some of them?
What is copy pending status in db2?
What is sqlca’s maximum length?
what is the responsibility of the construction superintendent
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What db2 400?
What is db2 optimizer?
What are the various isolation levels possible?
What is package in db2 mainframe?