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

Answer Posted / s

255 tables

Is This Answer Correct ?    17 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is performance tuning db2?

605


What is null value in db2?

557


What are the prerogatives?

612


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

738


Why do we need reorg in db2?

555






Differentiate between cs and rr isolation levels? Where do you specify them?

572


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1618


What is db2 optimizer?

763


How to take backup of table in db2?

591


Who uses db2?

569


What is a db2 cursor?

618


How do you find the maximum value in a column in db2?

644


How can you do the explain of a dynamic sql statement?

629


What is the use of db2 optimizer?

603


How to restart a DB2 program?

1353