Answer / s

RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

Define sqlca.

1 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1 Answers   Infosys,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1 Answers   IBM,

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What is a host variable?

3 Answers  

---

What is ibm db2 connect?

1 Answers  

---