How to update more then one record using update?

Answer Posted / sivakumar sekharannair

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a corelated subquerry?

651


How can we read records for specific member in CL? AND rpg?

228


Can one database have multiple instances?

579


How to fetch the last row from the table in SQL (db2)?

1035


What is performance tuning db2?

611






What is table space in db2?

574


What is rct?

747


Differentiate between cs and rr isolation levels? Where do you specify them?

576


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

651


What are bind parameters in db2?

611


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1589


Are view updateable?

627


Outputs of explain are with matchcols = 0. What does this signify?

613


What is the role of the data page in the db2 database?

583


How do I delete a column in db2?

674