i m trying to update 2 tables in single update statement. but it's not working
...

Create procedure abc()
BEGIN


UPDATE lrp_data, fam_class_mdata SET s_jan = gro_sales / 12,
s_feb = gro_sales / 12,
s_mar = gro_sales / 12,
s_apr = gro_sales / 12,
s_may = gro_sales / 12,
s_jun = gro_sales / 12,
s_jul = gro_sales / 12,
s_aug = gro_sales / 12,
s_sep = gro_sales / 12,
s_oct = gro_sales / 12,
s_nov = gro_sales / 12,
s_dec = gro_sales / 12,
userid = 'evergreen',
dbtimestamp = CURRENT_TIMESTAMP
WHERE fam_class_mdata.prd_family_type = 'A' AND fam_class_mdata.prd_family = lrp_data.gl_prd_family and lrp_data.year = 2009;

END


it shows n error

sqlcode:-104

I don't think this is allowed ...

Why do you want to do in one stmt ?

Update works on a single table only.

In DB2 LUW, you can apply an update to a SELECT statement - but only if there is a unique mapping from a single column/value to the underlying base tables.

In your case, this seems to be unnecessary. You should just update LRP_DATA and use a subselect to filter the rows based on some content in FAM_CLASS_MDATA.