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 Posted / 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 View All Answers
What is db2 instance?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the various data types available in db2?
What is db2 stogroup?
What is bind and rebind in db2?
What is the meaning concurrency in the db2 database?
What is dclgen in db2?
How do I copy a table in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is check constraint. Explain with example.
Why select is not preferred in embedded sql programs?
How does cobol compile db2 program?
List out the three types of page locks that can be held.
List some fields from sqlca?