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 / lu
when u bind , 5 queries has 5 sql statements in 1 DBRM, its
regroup into 1 package, 1 plan...Plan is a collection of
packages..
correct me if i'm wrong..
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
How to find the number of rows in a db2 table?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the maximum length of sqlca?
What is the difference between drop table and delete table?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do you select a row using indexes in db2?
Mention the definition of cobol in varchar field.
What is the connection string to connect to the DB2 Database ?
How to create backup table in db2?
What is ibm db2 database?
How many databases are there?
List out the three types of page locks that can be held.
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.
Can one database have multiple instances?
What is iseries database?