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.

What is the physical storage length of date data type?

1188

---

Is db2 a programming language?

982

---

What is the purpose of using commit?

1039

---

How to test SQL -911 error while developing COB-DB2 program

7441

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1085

---

What is copy pending status in db2?

1068

---

List some fields from sqlca?

1000

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3519

---

What is the difference between spufi and qmf?

1053

---

How can we retrieve the total number of records in RPG & CLLE?

577

---

What is the use of runstats in db2?

1021

---

What is reorg?

1071

---

What are db2 tables?

1049

---

How do I add a column to an existing table in db2?

976

---

What is the purpose of rollback and commit?

1085

---