For this concern you can use or oprator along with where clause, Example

How to update more then one record using update?

Question Posted / pratap singh

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

Please Help Members By Posting Answers For Below Questions

How can you classify the locks in db2?

626

How to find schema of a table in db2?

568

What is sqlca?

612

What is explain in db2?

582

What is dclgen (declaration generator)?

596

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

622

Who uses db2?

569

Is db2 relational database?

567

Is schema the same as database?

625

What are packages in db2?

593

What is the difference between cursor and select statement?

609

How do I import a csv file into db2?

556

Explain about rct.

644

What is an instance database?

598

What is dbrm?

636