If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

How to find the number of rows in a db2 table?

0 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---