Interested to Buy Any Domain ? << Click Here >> for more details...
Bind concepts in DB2 cobol
- 10 Answers
- 30646 Views
- IBM, TCS, TRD, Virtusa, I also Faced
- E-Mail Answers
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 is db2 instance?
Explain the contents that are a part of dclgen.
What r the comman abends in db2, jcl and cobol???????
How can you find out the # of rows updated after an update statement?
what is db2 restart?
What is a bind card?
What is universal database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Is db2 relational database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are host variables in db2?
What are the contents of a dclmgen?
Name the lockable units in DB2?
What is db2 plan table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
