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
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Explain how can you do the explain of a dynamic sql statement?
What is ibm db2 used for?
Discuss about db2 bind?
How to execute stored procedure in db2 command editor?
How many types of page locks can be held in db2?
What is bind package and plan in db2?
What is dbrm library?
What is data manager?
What is syscat in db2?
Before you give the explain statement, what are the prerogatives?
What is buffer pool?
How to create backup table in db2?
What are union and union all?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.