update multiple rows in DB2 query

ZIMI SAHOO · New User Joined: 12 Feb 2013 Posts: 2 Location: India

Hi I'm currently using the query as
EXEC SQL
UPDATE table name
SET ACTION_TIMESTAMP = CURRENT TIMESTAMP
, AUDIT_ID = :Table-AUDIT-ID
WHERE SRC__NBR = :table-SRC--NBR

The value :table-SRC-IDENT-NBR is from a file.
Now its updating one row at a time. Is there any way to update multiple rows simultaneously.

Pandora-Box · Posted: Tue Feb 12, 2013 6:51 pm

If your tables field SRC_NBR going to have only one value then you dont need to check for ':table-SRC--NBR'

There is no other option of updating multiple rows unless you set up the code to have a setup for Mutli row update like having IN or passing the data to array and have them as Host variables

Or Is the requirement to update the current timestamp for all the valid where clauses?

ZIMI SAHOO · New User Joined: 12 Feb 2013 Posts: 2 Location: India

No its not just time stamp there are many field I'm updating.
Could you please tell me how to pass the data to array and have them as Host variable. I've no idea.
Thanks!

sushanth bobby · Posted: Wed Feb 13, 2013 10:26 am

Sonali,

Look at Merge Statement and here is the example.

Thanks,
Sushanth