Answer / manisha

DB2 bind is a type of compiler for SQL statements which
read sql statement from DBRM and produces a mechanism to
access data as divided by SQL statement being bound.

Answer / elavarasi

DB2 Bind- Provide access path to db2 table

Answer / satyadev kumar

DB2 bind is will give access to the db2 table trough the
sql statement.

What does the REORG Utility do?

2 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

How is the value function used?

0 Answers  

---