we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

When reorg is used?

0 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

How do you find the maximum value in a column in db2?

0 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

How to find primary key of a table in db2?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---