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.

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

How would the varchar column remarks defined?

0 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

When do you specify the isolation level? How?

1 Answers  

---

Why do we need reorg in db2?

0 Answers  

---