Answer / s

SELECT is a Data Manipulation Language statement that is
used to select rows from a table.

Are views updatable ?

4 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

What is the STOSPACE Utility used for?

1 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

How to create backup table in db2?

0 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 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,

---

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 update more then one record using update?

5 Answers   IBM,

---