How to update more then one record using update?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you quickly find out the # of rows updated after an update statement?

705


What are the various isolation levels possible?

736


What is null indicator in cobol db2?

675


What is host variable?

683


i want to maintain uniqueness on pdf without make lf??????????

1739






What happens in bind step in a db2 program?

649


What does db2 mean?

663


What is the use of runstats in db2?

668


Which isolation level provides maximum concurrency?

768


What is the role of schema in the db2 database?

757


Which components manage deadlocks in db2?

704


What is a db2 schema?

862


Describe major components of db2?

742


What is the difference between oracle and db2?

675


What is a bind in db2?

680