Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11296 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Before you give the explain statement, what are the prerogatives?
What db2 400?
What is the physical storage length of the data types date, time, and timestamp?
Why do chiropractors use drop table?
How is a typical db2 batch pgm executed?
What does db2 mean?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
List down the data types in the db2 database.
What is the information associated with sysibm.syslinks table?
Which is faster delete or truncate?
How do you eliminate duplicate values in db2?
How to execute stored procedures?
What is host variable?
