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
- 3680 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
Name the various locking levels available?
What is the difference between dbm cfg and db cfg file in db2 ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of commit in db2?
Is it possible using max on a char column?
What is rct?
If I have a view which is a join of two or more tables, can this view be updateable?
How to restart a DB2 program?
How to find the number of rows in db2 tables?
What does reorg do in db2?
What is phantom read in db2?
define clustering index.
Explain various types of locks in db2?
How to retrieve rows from a db2 table in embedded sql?
Define predicate?
