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

Is ibm db2 free?

994

What is the maximum number of columns in a db2 table?

1265

What is a db2 schema?

1209

What is temporal table in db2?

1019

How to test SQL -911 error while developing COB-DB2 program

7527

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1083

How to take backup of table in db2?

1053

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

1079

What do you mean by commit and rollback?

1025

What is bind plan?

1036

What is the picture clause of null indicator variable?

1116

Outputs of explain are with matchcols = 0. What does this signify?

1041

What is the difference between bind and rebind in db2?

1425

What is the difference between nvl and coalesce?

1048

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1064