Bind concepts in DB2 cobol
Answer Posted / 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.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are iseries servers?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are union and union all?
How to find the number of rows in db2 tables?
What is a buffer in memory?
What is db2 plan table?
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 .....
List down the types of triggers in the db2 database?
What does db2 blu stand for?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the difference between plan and package in db2?
What is null value in db2?
What is database manager in db2?
What is dbrm?
Explain db2.