Interested to Buy Any Domain ? << Click Here >> for more details...
Bind concepts in DB2 cobol
- 10 Answers
- 30621 Views
- IBM, TCS, TRD, Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 76 Yes | 8 No |
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.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / lavenderguy
Brillian answer suresh..it helped me lot....
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sheetal
simple and best answer.very helpful,thanks a ton.
| Is This Answer Correct ? | 5 Yes | 0 No |
Awesome explanation in Easy language...
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / sharath
Nice Explanation from suresh, Appreciate if he gives more information about Bind function.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the disadvantages of PAGE level lock?
what is different three logs in DB2?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is buffrpool? Where we use it ?
Explain the use of the WHERE clause.
How to update more then one record using update?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the different types of base tables?
what's the error code for Unique Index Violation?
How can you classify the locks in db2?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
COBOL 
