What is a DB2 plan?

Answer Posted / guest

It establish relation between application program and DB2
tables.

Is This Answer Correct ?    53 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a collection in db2?

580


How can you classify the locks in db2?

636


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1236


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2046


Is ibm db2 open source?

586






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?

1626


When the like statement is used?

640


Name the lockable units in DB2?

664


What is check constraint in db2?

608


How to check last update on table in db2?

628


What is the max length of sqlca?

764


What is dbrm library?

578


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

650


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

749


What are the various isolation levels possible?

649