Answer / s

CS - page or row locks are released as soon as the cursor
is moved to another row or page.

RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.

Explain about dbrm.

0 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

what is db2 restart?

0 Answers  

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

How does db2 sample database connect?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What is read-only cursor?

1 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---