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 db2 purescale?

1052

Mention some fields that are a part of sqlca.

1096

Can you tell me how can you find out the # of rows updated after an update statement?

1147

What is db2 connect?

1125

What is the use of commit in db2?

1144

How to check last update on table in db2?

1100

What is meant by explain?

1194

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222

what is the role of the cursor in db2?

1112

What is the physical storage length of the data types date, time, and timestamp?

1139

What is a Foreign Key?

1140

Mention the downsides of page level lock.

1217

What is load replace in db2?

1050

Define db2.

1172

What is the purpose of rollback and commit?

1287