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
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a db2 collection?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How is deadlock resolved?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is scrollable cursor in db2?
How and when does the db2 enforces the unique key?
Is db2 free?
What do you mean by cursor?
What is the maximum size of varchar data type in db2?
What is dpf in db2?
What is the maximum No of rows per page?
What is db2? Explain.
What is cursor stability in db2?