update kmms.tb_trade_cust
set
mobile=b.mobile
,phone=b.tel
,fax=b.fax
,email=b.email
,bp=b.bb
,comm_addr=b.address
,zip=b.post_zip
,idcard_addr=b.id_address
,capital_account_status=e.id
,custDistin=c.id
,capital_account_type=d.id

from kmms.tb_trade_cust a

inner join olap.tb_dim_account_info x on a.cust_id=x.account_id

inner join params.tb_branch z on x.branch_code=z.branch_code

inner join closing.tb_client_info b on x.branch_code = b.branch_code and x.capital_account = b.capital_account

inner join kmms.tb_show_list c on c.code=x.company_level_id and c.type='custBase.custScope'

inner join kmms.tb_show_list d on d.code=x.class_id and d.type='BusinessClientBase.custNumType'

inner join kmms.tb_show_list e on x.status=e.code and e.type='BusinessClientBase.custNumStatus'
where z.sub_company_code=@data_unit_code
-----------------------
这是sqlserver存储中的一个update语句，要依植到db2上去，谁能把它转化成db2版啊？