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.

How to find the number of rows in a db2 table?

1116

---

How to fetch the last row from the table in SQL (db2)?

1651

---

What's The Error Code For Unique Index Voilation?

1230

---

How can you count the number of rows from a table tab?

1086

---

What is view db2?

1065

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

---

Is db2 a database?

958

---

What is ibm db2 client?

936

---

What is dbrm library?

1047

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1057

---

Mention the downsides of page level lock.

1159

---

What is scrollable cursor in db2?

1053

---

What is a system catalog table in db2?

1184

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

---

How do I start db2 in windows?

1086

---