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 / devika
update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'
| Is This Answer Correct ? | 3 Yes | 0 No |
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do I add a column in db2?
What is package in db2 mainframe?
How can we read records for specific member in CL? AND rpg?
What does CURRENTDATA option in bind indicate
What is catalog database in db2?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What kind of database is db2?
Can we install 2 different versions of Db2 on same mainframe?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What if we fail to give values in columns declared as NOT NULL ?
What is with ur in db2?