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
- 3745 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 do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is meant by a unit of recovery?
what is the name of the default db2 catalog database?
What are some characteristics of columns that benefit from indexes?
What is the maximum size of a char data type in db2?
What is ibm db2 database?
What is the physical storage length of time data type?
What does a deadlock mean in DB2?
What are foreign keys?
Explain in detail about buffer manager and its functionalities?
What is the error code -803 ?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
COBOL 
