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
- 3083 Views
- HSBC, I also Faced
- E-Mail Answers
Answer / devika
update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the syntax of SELECT statement when embedded in a COBOL program?
What is meant by index cardinality?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Explain in brief how does db2 determine what lock-size to use?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is the difference between Where and Having Clause
Compare a subselect to a join?
What are column-name qualifiers used?
How do I create a view in db2?
What is the maximum length of sqlca?
What is a Database Request Module(DBRM)?
What is temporal table in db2?
COBOL 
