Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

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

2 Answers   CGI, Value Labs,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

How to find primary key of a table in db2?

0 Answers  

---

Can you Average the Characters ?

3 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is the meaning of -805 SQL return code?

3 Answers  

---