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 table space in db2?

1072

---

Mention data types used in db2 ?

1200

---

Is it possible using max on a char column?

1192

---

How do you pull up a query which was previously saved in qmf?

1205

---

What is the maximum size of varchar data type in db2?

1177

---

What is the use of db2?

1114

---

Explain correlated sub-queries.

1096

---

What is the difference between spufi and qmf?

1204

---

Explain the function done by data manager?

1331

---

When the like statement is used?

1280

---

List down the data types in the db2 database.

1181

---

What are the 2 sqlcodes that are returned?

1233

---

How to run db2 command in windows?

1245

---

What is the difference between cursor and select statement?

1152

---

How do we specify index to include or not during bind process.

2175

---