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

How to update more then one record using update?

Question Posted / guna

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

Please Help Members By Posting Answers For Below Questions

What is null indicator in db2?

1110

Are views updateable?

1155

Mention some fields that are a part of sqlca.

1033

Which is faster delete or truncate?

1127

Is db2 free?

1094

What is explain in db2?

1020

What is dclgen (declaration generator)?

1059

How many types of page locks can be held in db2?

1040

How do I connect my db2 database to ibm?

1050

What is the difference between plan and package in db2?

1112

What is db2 connect?

1068

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

Describe major components of db2?

1091

Where do you specify them?

1279

Is db2 a database?

968