What is the diff bet plan,package,dbrm?
Submitted by: AdministratorPlan is generated when you compile the DB2-SQL program.
This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname)
DBRM: Data base request module is generated by precompiler which contains the sql statements which are separated from the source program.
PACKAGE: By binding the DBRM package is generated.Package contains the internal structure of the original sql statements.
PLAN: It is the combination of packages that are bind to form a PLAN.
Submitted by: Administrator
This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname)
DBRM: Data base request module is generated by precompiler which contains the sql statements which are separated from the source program.
PACKAGE: By binding the DBRM package is generated.Package contains the internal structure of the original sql statements.
PLAN: It is the combination of packages that are bind to form a PLAN.
Submitted by: Administrator
Read Online IBM DB2 Job Interview Questions And Answers
Top IBM DB2 Questions
☺ | what are the bind parameters IBM DB2? |
☺ | What is sqlcode -811? |
☺ | What is sqlcode -922 ? |
☺ | Cursors can be declared in both working-storage & procedure |
☺ | Can you have more than one cursor open at any one time in a program ? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |