suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

What are union and union all?

0 Answers  

---

What is referential integrity?

5 Answers  

---

What are delete-connected tables?

1 Answers  

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

How to take backup of table in db2?

0 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

cobol-db2 runjcl please?

2 Answers   DELL,

---