Answer / mdvasanth86

Depends on your site/ project...

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

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

What does the sqlcode of -818 pertain to?

3 Answers  

---

What is commit in db2?

0 Answers  

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

What is a page?

2 Answers  

---

What is the default page size of buffer pools?

0 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

What is a view? Why use it?

2 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---