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..
Answer / devika
update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'
Is This Answer Correct ? | 3 Yes | 0 No |
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is QUIESCE?
Is it possible using max on a char column?
What is host variable in db2 cobol?
What is a DB2 bind?
How do I delete a column in db2?
What is the syntax for FETCH in DB2 ?
Explain the use of the WHERE clause.
what is difference between Plan and Package
Name the various locking levels available?
Which component is used to execute the sql statements?
What is precompiler in db2?