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 / shailesh
1 DBRM only.
Correct me if I am wrong !
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is host variable?
Is ibm db2 open source?
What is an instance database?
What does db2 stand for?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Define predicate?
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?
What is commit in db2?
How do I add a column in db2?
How do I add a column to an existing table in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is a db2 collection?
How do you find the maximum value in a column in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
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 .....