Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3742 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
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is db2?
What are the full forms of spufi and dclgen and why are they used?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is db2? Explain.
Explain how can you do the explain of a dynamic sql statement?
Is db2 free?
What is bind in db2?
Define declaration generator (dclgen).
What is commit in db2?
What does db2 plan contain?
How do you stop a db2 database in linux?
How do I delete a table in db2?
Explain db2.
