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

Why do we need reorg in db2?

1042

What does reorg do in db2?

1074

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3632

What is runstats and reorg in db2?

1356

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1288

What is schema in db2?

1081

What is precompiler in db2?

1075

What is collection in db2 bind?

1061

What parameters are used to control the free space in DB2?

1094

What is an instance in db2?

1084

What is the purpose of using commit?

1153

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3007

What action db2 takes when a program aborts in the middle of a transaction?

1192

What is explain plan in db2?

1048

What is database reorganization?

1183