Answer / pratap singh

For this concern you can use or oprator along with where
clause, Example

WHERE DEPT_ID='D110' OR 'D001' OR 'D105'

Answer / sivakumar sekharannair

update query without "where" command will update multiple
rows in the table;

Answer / k

Don't give where command in update query

Answer / selvam a

Update a table using a symbolic cursor:
UPDATE WHERE CURRENT OF limits the scope of DB2 updates to
one row at a time, specifically the row your cursor is
positioned on.

Answer / guna

UPDATE table1 set columnname = (SELECT columnname from
table2 where some condition)

You can also use EXISTS instead of '=' for updating

What is the difference between Primary key and unique index?

6 Answers  

what are stage one indexable predicates?

1 Answers  

Is it possible using max on a char column?

0 Answers  

What is a DB2 bind?

1 Answers   Logica CMG,

What is a Database Request Module(DBRM)?

4 Answers  

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

Are views updateable?

0 Answers  

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

Why select is not preferred in embedded sql programs?

0 Answers  

What is meant by a unit of recovery?

1 Answers  

What is the difference between plan and package in db2?

0 Answers