Interested to Buy Any Domain ? << Click Here >> for more details...
Why PS file called Physical seqential file?How to sore data
in sequential file and ESDS file?
What is the use of DBRM,PLAN,package and Collection.
- 1 Answers
- 4415 Views
- I also Faced
- E-Mail Answers
Answer / srini
What is the use of DBRM,PLAN,package and Collection.??
DBRM is just a SQL/DB2 part of a embeded COBOL and DB2
program,basically DB2 Precompiler creates this by just
commenting out all SQL/DB2 part.
PLAN is a collection of packages and its an executable for
DB2 system just like a loadmodule for Cobol.Plan stores all
the accee paths for table/database.
Package is a smaller version of package,we can say its a
bound DBRM or a plan for a single program,but its not
executable by itself,we can to bound it into plan,so that
plan can be executed.
We can directly have PLAN instead of going to package,but
we have many advantages of using package over the plan as
below.
1.We can have seperate versions(like same DBRM can be bound
into test package,model office package and production
package)
2.more granularity i.e when ever we change some sub
routine,we no need to bind all the calling/called chain and
block the entire transaction,we can just rebind the
perticular package so that the plan while executing
automatically picks it up the latest version of the package.
3.involves less cost,use the above said example.
4.easy maintanance.
COLLECTION
Collection is just a logical name given for a set of
packages that can be sed while creating the plan....there
is no physical existance of a collection...its a matter of
convenience to the user.
Hope this answers your query on DBRM,plan,package and
collection,if not let me know.
| Is This Answer Correct ? | 2 Yes | 0 No |
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What's the difference between DB2 active log and archive log? Thanks a lot...
Do we need cursor for Count(*)?
What is package in db2 mainframe?
What is bind and rebind in db2?
What are the contents of a dclmgen?
can any body explain about plan and pakage in detail....
What is a DB2 catalog?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
How to update more then one record using update?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
COBOL 
