Interested to Buy Any Domain ? << Click Here >> for more details...
what is the maximum number of tables that can be joined ?
- 8 Answers
- 20646 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 |
Can we declare DB2 HOST variable in COBOL COPY book?
Can we use select * statement in cobol program without giving field names ???
How is the SUBSTR keyword used in sql?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What are catalog tables in db2?
Q3. How will you fetch duplicate values from a DB2 table?
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 is runstats and reorg in db2?
What is a Database Request Module(DBRM)?
What is the difference between primary key & unique index ?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is UNION,UNION ALL?
COBOL 
