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

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


Once you create a view, where would information about the view be stored?

1 Answers  


How can you do the explain of a dynamic sql statement?

0 Answers  


What are PACKAGES ?

3 Answers  


What is the maximum size of varchar data type in db2?

0 Answers  






How connect db2 database to datastage?

0 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


What is db2 optimizer?

0 Answers  


What are the disadvantages of PAGE level lock?

3 Answers  


What is package in db2 mainframe?

0 Answers  


What is a Cartesian product?

2 Answers  


What are types of indexes?

0 Answers  


Categories