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
- 3741 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 |
Is it mandatory to use DCLGEN? If not, why would you use it at all?
what are bind concepts in db2 cobol?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Can you tell me how can you find out the # of rows updated after an update statement?
What is dbrm? What it contains? When it will be created?
What is SPUFI?
How to take backup of table in db2?
How does coalesce work?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What else is there in the PLAN apart from the access path?
How can we read records for specific member in CL? AND rpg?
How to restart a DB2 program?
COBOL 
