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
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What do you mean by cursor?
How can we retrieve the total number of records in RPG & CLLE?
How can we read records for specific member in CL? AND rpg?
What is a page in db2?
What does reorg do in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is db2 command?
What is sqlca’s maximum length?
What is null value in db2?
What is node in db2?
List out the data types available.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Which is faster delete or truncate?
How connect db2 database to datastage?