How to update more then one record using update?

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

Question Posted / sriramu.t

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

Answers were Sorted based on User's Feedback

How to update more then one record using update?..

Answer / 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

How to update more then one record using update?..

Answer / sivakumar sekharannair

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

Is This Answer Correct ?

2 Yes

1 No

How to update more then one record using update?..

Answer / k

Don't give where command in update query

Is This Answer Correct ?

1 Yes

1 No

How to update more then one record using update?..

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.

Is This Answer Correct ?

0 Yes

0 No

How to update more then one record using update?..

Answer / guna

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

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

Is This Answer Correct ?

0 Yes

2 No

Post New Answer