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..



Could you please let me no the query for below I have table name xyx under this there is column n..

Answer / devika

update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


Mention the different locking levels that are available in db2.

0 Answers  


What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  


How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,


What is a root page?

1 Answers  






What is db2 look?

0 Answers  


What is db2?

0 Answers  


Is it possible using max on a char column?

0 Answers  


How many clustering indexes can be defined for a table?

2 Answers  


can we drop column from a table

7 Answers   INDUS,


What is IMAGECOPY ?

6 Answers  


Mention the various locks that are available in db2.

0 Answers  


Categories