what is the maximum number of tables that can be joined ?
- 8 Answers
- 21093 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 |
Describe what a storage group(STOGROUP) is?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is check constraint. Explain with example.
What do you need to do before you do EXPLAIN?
What is the difference between SYNONYM and ALIAS?
pls explain the precompilation process of cobol-db2 pgm
How to resolve -805 error in DB2?
How do you retrieve the data from a nullable column?
What is meant by index cardinality?
What is buffer pool and list some of them?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
what is difference between Static call and Dynamic call? How does it function?
COBOL 
