Answer / suresh ramaiyan

The first thing is Host languages.
Whatever we are using in cobol (other than cobol langauge
command) that are called HOST language.

DB2 is also one of the host language.
COBOL compiler does not know the host language and does not
compile the same.
we will take cobol-db2 program..
Here, we are introduce PRE-COMPILER....
Pre-compiler will spilt the cobol db2 program into two
module.
1. Cobol program (fully cobol,all the host language
commands will get replaced with "MOVE and CALL" statements.
2. DBRM (DataBast Request Module)- only those commands,
which are code within 'EXEC SQL .. END-EXEC.

Now, we have spited and we have separate for each..(COBOL
and DB2)..
We know about compilation process for COBOL.
Now come to BIND process....
Bind is nothing but, compilation process of DBRM.
The output of this compilation process(BIND) is Package.
If we bind the packages then we will get Plan/Application
plan.
When we do the link-edit the cobol program, a thread will
be created between the load module of cobol and plan.

Answer / suresh ramaiyan

As Sharath requested...

As we all know, all our programming(high level language) needs to be converted(compiled) into system-understandable(low level language) to be executed.
So, SQL statements in the COBOL programs needs to be compiled, such process is called BIND. DB2 Bind compiles all your sql statements(dbrm) into an executable format.
BIND also verifies all the information in the program with DB2 databases..
Here are the list of items happening through out BIND process (as of I know :) )
1. Syntax check of SQL query
2. Availability of Tables & columns in the database
3. It uses DB2 Optimizer to create the better access path. A clear way to read/update/delete table. like.. what are the columns are reading, which indexes needs to be used, the table space..etc.

So after BIND process finished, the Package/Plan contains exactly how to do, what we meant to do in system understandable language.

Hope it helps.. My apologies, if I confused or missed something.

Answer / guest

awesome reply by suresh..to the point..

Answer / lavenderguy

Brillian answer suresh..it helped me lot....

Answer / sheetal

simple and best answer.very helpful,thanks a ton.

Answer / raghunadhareddy

Excellent explanation Suresh

Answer / sonu

Nice answer!!!!!!!!!!

Answer / vaneesh khurana

Awesome explanation in Easy language...

Answer / sheethal

thanks a lot....

Answer / sharath

Nice Explanation from suresh, Appreciate if he gives more information about Bind function.

Highlight all the advantages that are attached to a package.

0 Answers  

What is the database descriptor?

2 Answers  

what is the difference between join and union?

4 Answers   IBM,

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

can we drop column from a table

7 Answers   INDUS,

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

What is the function of buffer manager?

1 Answers  

what is a trigger and types of triggers

3 Answers   HSBC,

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

Mention the various locks that are available in db2.

0 Answers  

What is Reorg Recovery? when will you run it?

2 Answers  

What is Declaration Generator(DCLGEN)?

1 Answers