Answer / s

Packages are single bound DBRMs which contains SQL
statements of a single application program or subroutine.
Before the application program can be executed, you need to
bind a plan. The plan can be bound with DBRM members and/or
Package list. Without the use of packages, if there is any
change made to the program, even if there are no changes to
the SQL, the whole plan need to bound which cause
unavailabilty of the plan and it is resource intensive
since all the unrelated DBRMs are also need to be bound.
With the use of packages, only the package need to be bound
without the need to bind the plan. Also bind parameters can
be specified at package level rather than plan level

Answer / guest

First u need to know the concept precompliation and
compliation process of db2 cobol program...

the maina dvange of pakage is, supose u have cobol db2
program, this prgoram is using 4 sub programs. if any one
of the sub programs undergoes changes u need to precompile
the main program. this can avoided by using the pakage
concept.

so u need to create one pakage for on sub program. if any
sub programs undergoes any change, u need to compile only
sub program.

Filnally one program will have one pakage and one DBRM lib.

How does cobol compile db2 program?

0 Answers  

---

Explain the use of the WHERE clause?

1 Answers  

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

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 .....

0 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

On which levels locks can be applied?

0 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How do I change the column size in db2?

0 Answers  

---