Answer / s

DCLGEN is declarations generator that reads the catalog
tables and generates DECLARE TABLE statments and host
language data structures. It ensures that the column data
types and length match the host variables and minimizes the
SQL errors during bind time

Answer / kavya

DCLGEN is a DB2 utility.If we provide table details,it will
generate DB2 structure and host variable structure of the
table.It can also generate NULL indicators for the NULL
columns.This output is stored in a PDS member.These members
are included in the program using the INCLUDE<pds member>.

What is meant by the attachment facility?

3 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What will the FREE command do to a plan?

2 Answers  

---

what are bind concepts in db2 cobol?

0 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---