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
- 3084 Views
- HSBC, I also Faced
- E-Mail Answers
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
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to get the ddl of a table in db2?
What is the clustering index in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the purpose of rollback and commit?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the difference between dbm cfg and db cfg file in db2 ?
What is schema in db2?
What are db2 objects?
What are the rules for db2 programming?
What is nvl in db2?
What is plan in cobol db2?
How do you stop a db2 database in linux?
Before you give the explain statement, what are the prerogatives?
Why db2 is called db2?
