Answer / abhishek kumar

-803 is th error code for the Unique Index Violation

Answer / bhanu prasad

2803

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What does the RUNSTATS Utility do?

4 Answers  

---

---

How do you define a correlated name?

1 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

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  

---

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

0 Answers  

---

difference between group clause and order clause

1 Answers  

---