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 difference between spufi and qmf?

716

What is the usage of open cursor command?

684

What is access path in db2?

638

What is the maximum length of sqlca?

980

What is iseries database?

672

What type of database is db2?

607

What is the latest version of ibm db2?

826

Which components manage deadlocks in db2?

704

What is netezza database?

664

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

711

What is dpf in db2?

753

What is the use of runstats in db2?

668

Which component is responsible for db2 startup and shutdown?

712

what are bind concepts in db2 cobol?

731

What is bind package and plan in db2?

696