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 / sunil a
1 DBRM , 1 PACKAGE and 1 PLAN
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the result of open cursor statement?
How can you find out the # of rows updated after an update statement?
What is db2 instance?
How do I create a view in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a cursor in programming?
Describe major components of db2?
Explain in brief how does db2 determine what lock-size to use?
What does sqlcabc has?
What is the purpose of using commit?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Define data page.
What is the information associated with sysibm.syslinks table?
How do I add a column in db2?