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,

---

select 100 records from million records ?

2 Answers   Verizon,

---

How does a cursor work?

0 Answers  

---

What is the use of dclgen in db2?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

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,

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

What is package versioning? Please give an example.

1 Answers  

---

What is an intent lock?

3 Answers  

---

What is reorg in database?

1 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---