Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11564 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pratap singh
For this concern you can use or oprator along with where
clause, Example
WHERE DEPT_ID='D110' OR 'D001' OR 'D105'
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to connect to db2 database from windows command line?
What is iseries database?
How many databases can be created inside an instance in db2 ?
What is the maximum size of varchar data type in db2?
How to view db2 table structure?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to check table size in db2 sap?
When the like statement is used?
What is bufferpool in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is bind plan?
can we view the access paths created by dbrm ? how ? thx
Why db2 is called db2?
Mention the location where the output received from explain statement is stored.
Which is faster delete or truncate?
