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
- 3695 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 |
How Plan is created while executing the query using SPUFI?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is buffer pool?
What keyword does an SQL SELECT statement use for a string search?
What is host variable in db2 cobol?
What is the maximum size of a char data type in db2?
How do I add a column to an existing table in db2?
What is a data page?
What is plan in cobol db2?
Normalization in DB2 – first normal form, second normal form
what is the difference between declaring the cursor in WS section and Procedure division?
What is db2 connect?
COBOL 
