what is the maximum number of tables that can be joined ?

Answers were Sorted based on User's Feedback



what is the maximum number of tables that can be joined ?..

Answer / s

255 tables

Is This Answer Correct ?    17 Yes 9 No

what is the maximum number of tables that can be joined ?..

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

what is the maximum number of tables that can be joined ?..

Answer / oraclesword

You can have the maximum upto 255 Tables

Is This Answer Correct ?    5 Yes 0 No

what is the maximum number of tables that can be joined ?..

Answer / varun

15

Is This Answer Correct ?    11 Yes 7 No

what is the maximum number of tables that can be joined ?..

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

what is the maximum number of tables that can be joined ?..

Answer / ashish kumar(einstein)

u can have as many tables as u want

Is This Answer Correct ?    6 Yes 3 No

what is the maximum number of tables that can be joined ?..

Answer / mithun paul

I think 32.

Is This Answer Correct ?    2 Yes 7 No

what is the maximum number of tables that can be joined ?..

Answer / sathishkumar

43

Is This Answer Correct ?    3 Yes 8 No

Post New Answer

More DB2 Interview Questions

Why select is not preferred in embedded sql programs?

0 Answers  


How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,


In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


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?

1 Answers   HeadStrong,






What is lock escalation in db2?

0 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


Write a query to retrive partial string.

2 Answers  


What language is db2 written in?

0 Answers  


How can you classify the locks in db2?

0 Answers  


Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,


Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  


Categories