what is the maximum number of tables that can be joined ?
Answer Posted / varun
15
| Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What are the different types of base tables?
What is load utility in db2?
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?
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
How to view db2 table structure?
What is sqlca?
What is collection in db2 bind?
Mention the various locks that are available in db2.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Explain dclgen.
How to restart a DB2 program?
What is runstats db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Define predicate?
Explain about rct.