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

5 Answers
11298 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the two types of logging in the db2 database? Explain them.

1019

What is view db2?

1008

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2670

Explain dclgen.

1146

What is ibm db2 database?

953

What is an instance in db2?

987

What is the difference between plan and package in db2?

1039

What is package in cobol db2?

1078

Mention the definition of cobol in varchar field.

1180

What are concurrency issues?

1032

What is netezza database?

960

Is db2 a database?

914

What are the prerogatives?

1016

What is the connection string to connect to the DB2 Database ?

1062

How to run db2 command in windows?

1141