Answer / Babita Kumari

RUNSTATS is a DB2 utility that collects statistics about tables, indexes, and their contents. These statistics are used by the optimizer to make informed decisions about how to execute queries efficiently.

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

1 Answers   Virtusa,

---

What is a bind card?

1 Answers  

---

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  

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1 Answers  

---

What information is used as input to the bind process?

2 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

Explain dclgen.

1 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

What is db2 purescale?

1 Answers  

---

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

3 Answers  

---