Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20716 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 |
Explain how can you do the explain of a dynamic sql statement?
What is the difference between SYNONYM and ALIAS?
Where could you look if you had a question about whether a column has been defined as an index?
What is a predicate?
What is the physical storage length of time data type?
What is the difference between drop table and delete table?
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.
Explain dclgen.
What is SPUFI?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
Describe what a storage group(STOGROUP) is?
COBOL 
