Answer / s

DCLGEN reads the catalog tables and generates DECLARE TABLE
statements and host language data structures that are used
to receive the data. These DECLARE TABLE statements are
used by the precompiler to check the syntax of the SQL
statement.

Answer / elavarasi

copybook-db2 to cobol declarations

Answer / ramesh naidu

It contains the db2 equalent cobol variables called host variables

Answer / maveric

1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.
2. A host language copy book that gives the host variable definitions for the column names.

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is db2?

0 Answers  

---

What are packages in db2?

0 Answers  

---

What is a db2 package?

0 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---

How to handle null values in db2

4 Answers  

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is concurrency in db2?

1 Answers  

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

What does a deadlock mean in DB2?

0 Answers  

---