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

What is the use of dclgen in db2?

1082

How do you select a row using indexes in db2?

1133

Highlight all the advantages that are attached to a package.

1111

How to connect to db2 database from windows command line?

1061

What does a deadlock mean in DB2?

1160

What is ibm db2 database?

998

What are bind parameters in db2?

1044

What is rct?

1228

Explain about dbrm.

1040

What is null indicator in db2?

1107

What is node in db2?

1042

Mention the various locks that are available in db2.

1035

what is utility for parm lib

2370

How to find the maximum value in a column in the db2 database?

1074

Are views updateable?

1150