Interested to Buy Any Domain ? << Click Here >> for more details...
What is the logical entity between plan and Package?
- 5 Answers
- 8911 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar reddy
When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the various data types available in db2?
What is the role of schema in the db2 database?
What is db2 instance?
How to execute stored procedures?
What are the various isolation levels possible?
What is syscat in db2?
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?
How to retrieve rows from a db2 table in embedded sql?
What's The Error Code For Unique Index Voilation?
What is a buffer in memory?
Which component is used to execute the sql statements?
What is the difference between cursor and select statement?
What is cursor in dbms?
If I have a view which is a join of two or more tables, can this view be updateable?
Is db2 relational database?
