What is the purpose of rollback and commit?

0 Answers  

---

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

Which component is used to execute the sql statements?

0 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

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

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is a DB2 access path?

1 Answers  

---