About Binds and DBRM

IBM's flagship relational database management system

About Binds and DBRM

Postby sinmani » Thu Apr 25, 2013 4:43 pm

Hi forum, I have few doubts about the way we deal with dynamic called and static called COBOL-DB2 programs.
I am stating my understanding. Please correct me where I am wrong.

Case 1. Program A ( COBOL-DB2 program)
Calls program B ( COBOL-DB2 program) Dynamically.

Steps :
1. Now for the compile and bind procedure we will compile the programs separately.
2. There will be two loads for the two programs.
3. Two separate DBRM's.
4. We bind two different DBRM in two packages.
5. We bind both the packages in a single plan which can be executed.

Case 2. Program A ( COBOL-DB2 program)
Calls program B ( COBOL-DB2 program) Static call.

Steps :
1. Now when we compile program A it will include Load of program B as well.
2. There will be Single load for the two programs.
3. Single DBRM.
4. We bind this DBRM in one package.
5. We bind this package in a single plan which can be executed.

Is this is right way to go about it??
As long as you think you are a student, you are doing well.
The day you consider yourself as the master of the game..........well
Posts: 93
Joined: Thu Mar 22, 2012 10:02 am
Has thanked: 14 times
Been thanked: 0 time

Re: About Binds and DBRM

Postby Akatsukami » Thu Apr 25, 2013 7:43 pm

Note a compile never incorporates load modules; only a link-edit will do that.

Each source module generates a DBRM; therefore in case #2 you will do exactly what you do for case #1.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: About Binds and DBRM

Postby enrico-sorichetti » Thu Apr 25, 2013 8:49 pm

(2) nope ...

every cobol source compiled on its own will yield a DBRM

after that the bind process for plan/package/collection stuff will depend on Your organization standard
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2999
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Return to DB2


  • Related topics
    Last post