Without using cursor can we do mutiple update

kalaikala · New User Joined: 21 Jul 2007 Posts: 27 Location: Chennai

Hi,

In COBOL-DB2, Without using cursor can we do mutiple update (like mutiple insert)

rajesh_mbt · New User Joined: 27 Mar 2006 Posts: 97 Location: India

Hi Kalai
Ofcourse, you can do multiple update like insert at a time. You need cursor only to select multiple rows from table(s). If you don't mention key field/primary key field in the where condition while updating the table that will update multiple rows

There is no cursor require for this. Hope, am correct if my understanding is right :-)

kalaikala · New User Joined: 21 Jul 2007 Posts: 27 Location: Chennai

Thats ok. But i want to update for particular row (with key fields in where clause).

There is an insert statement is there in DB2, we can insert N number of rows. likewise is there anything like that?.

Bharath Bhat · Posted: Fri Mar 13, 2009 5:38 pm

You can update N number of rows if the where clause returns N number of rows. If you are asking whether you can specify an array (like multi-insert), then sorry, There's no such method.