before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

What is cobol db2?

0 Answers  

---

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

Mention the various locks that are available in db2.

0 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

Explain correlated sub-queries.

0 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---