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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1169

---

List some fields from sqlca?

1037

---

How to find schema of a table in db2?

998

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1253

---

What is the difference between db2 and oracle?

1106

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1079

---

Explain the benefits you can get from mainframe connect?

955

---

How to find primary key of a table in db2?

1046

---

How to check table size in db2 sap?

1011

---

What is a bind in db2?

1020

---

What is a db2 tablespace?

1044

---

What do you mean by commit and rollback?

1025

---

What is dclgen in db2?

1112

---

How to connect to db2 database from windows command line?

1037

---

List out the three types of page locks that can be held.

1135

---