DB2 COBOL Program

Question

If I have one DB2 COBOL program that calls 2 other DB2 COBOL routines, how many DBRMs, packages, plans will be created? If I change any of the routines, do I need to recompile and bind all the programs? I am really confused with DBRM, plans and packages.

Regards, Manasi

Answer 1

Oh my ... This is a huge topic, so the answer will be very simplified and therefore incomplete.

, DB/2 -. , . , , .

, :

• COBOL
• DB/2 DB/2

, , DB/2 .

/ , DB/2, DB/2. DBRM ( ). , EXEC SQL...END-EXEC DB/2. COBOL , , , .

DBRM, , SQL , , DB/2 SQL . DBRM ( PDS), DB/2 Binder, SQL DB/2 . DB/2 , COBOL. DBRM Binder .

, DBRM -, DB/2.

? .

- DBRM . , , ( ).

DBRM , . DB/2 ( , ). ? - DBRM. , , , DBRM.

, SQL DBRM, . . Bind , , . Bind Cards - " ", DB/2 Binder ( ). Bind , . Binder, . : , , .

, :

     Program -> (Pre-Compiler) -> Modified Program -> (COBOL compiler) -> Object -> (Link) -> Load Module 
                               -> DBRM -> (DB/2 Bind) -> Package

     Bind Cards -> (DB/2 Bind) -> DB/2 Plan
     Package(s) ->

- ( COBOL) DB/2. Plan JCL, - EXEC .

, :

DBRM?

DBRM , SQL EXEC

?

DBRM. 1:1

?

Bind Card. , .

, ?

DBRM , , DBRM. .

, DBRM , . 1:1, . , , - Bind Card, .

, DBRM , .