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,

---

How would the varchar column remarks defined?

0 Answers  

---

what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What is a Cartesian product?

2 Answers  

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---