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
How and when does the db2 enforces the unique key?
What is multi row fetch in db2?
Define sqlca.
What is the purpose of rollback and commit?
What is dclgen in db2?
What is clone table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the meaning concurrency in the db2 database?
Can you tell me how can you find out the # of rows updated after an update statement?
What is null in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do I add a column to an existing table in db2?
What is the function of logging in the db2 database?
What are the full forms of spufi and dclgen and why are they used?