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
- 3685 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 |
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
what is diffrence b/w file-aid tool and file-aid utility???
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
wht are the restrictions for union ?
how can u understand the end of the table ?
What is the syntax for FETCH in DB2 ?
How can you quickly find out the number of rows updated after an update statement?
How to find last record before record through SQLRPGLE?
Which are the db2 tools to protect integrity of the database?
what is the maximum number of tables that can be joined ?
COBOL 
