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
- 3612 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 |
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the maximum length of sqlca?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What are db2 objects?
What is the purpose of the QUIESE Utility?
What is a cursor in programming?
Is db2 a mainframe database?
What is ibm db2 database?
How do I optimize a query in db2?
What are the prerogatives?
COBOL 
