If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
Answer Posted / sampath
1 DBRM, 1 Package & 1 plan
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What are the prerogatives?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is sqlca?
What is nvl in db2?
What is runstats and reorg in db2?
Explain package in db2 and its advantages?
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?
What is phantom read in db2?
Why do we bind in db2?
What is drop table?
What is db2 look?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the default page size of buffer pools?
What action db2 takes when a program aborts in the middle of a transaction?
What language is db2 written in?