Answer / mdvasanth86

Depends on your site/ project...

Generally -911 (deadlock) &
SB37 (Space abends) are the most common ones.

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What is the difference between plan and package in db2?

0 Answers  

---

What is a db2 package?

0 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

How to find the number of rows in db2 tables?

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

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

0 Answers   Infosys,

---

Can you Average the Characters ?

3 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

Highlight all the advantages that are attached to a package.

0 Answers  

---