i want to execute 3 update commands in single query like multiple inserts:--
following query is getting executed priperly in DB2 command center as it treats it as 3 different queries.

update ppymt_pen_pct set ppymt_pen_pct = ? where arr_id_app = ? and ppymt_pen_ind = ? and yr_num = ?;update ppymt_pen_pct set ppymt_pen_pct = ? where arr_id_app = ? and ppymt_pen_ind = ? and yr_num = ?;update ppymt_pen_pct set ppymt_pen_pct = ? where arr_id_app = ? and ppymt_pen_ind = ? and yr_num = ?;

What i want is to update 3 rows based on diff where clauses in single statement.

Any help is really appreciated.

subhash

I am not clear about your requirement, but if you want to update a column with a value which depends on a given condition, you can try the next statement:

UPDATE TBL1 A SET A.COL1 =
( CASE WHEN A.C2 = ? AND A.C3 = ? AND A.C4 = ? THEN ?
WHEN A.C2 = ? AND A.C3 = ? AND A.C4 = ? THEN ?
ELSE ?
END )
WHERE ( A.C2 = ? AND A.C3 = ? AND A.C4 = ? ) OR
( A.C2 = ? AND A.C3 = ? AND A.C4 = ? ) OR
( A.C2 = ? AND A.C3 = ? AND A.C4 = ? )

good luck,
saludos, aloz.

Use CASE WHEN expression , that will resolve your problem.

for sytax check SQL reference Guide


Let me know if any question


LekhaRaju Ennam