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.

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

What is explain in db2?

0 Answers  

---

Define sqlca.

0 Answers  

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

what is a collection?

2 Answers  

---

Is db2 a mainframe database?

0 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---