update (select a.bidformula, a.askformula, b.engname from xprice_fpfeedparam a, param_ccypair b
where a.ratecode = b.CCYPAIRID and a.termid = 1 and b.engname like '%USD%') c
set c.bidformula = '0-|1_' || c.engname || '_O/N' || '_ASK|-|1_' || c.engname || '_T/N_ASK|' ,
c.askformula = '0-|1_' || c.engname || '_O/N' || '_BID|-|1_' || c.engname || '_T/N_BID|';
上面的语句在oracle中能正常执行，如何将它改成DB2能支持的语句
------解决方案--------------------------------------------------------
update xprice_fpfeedparam a
set bidformula = '0-
------解决方案--------------------------------------------------------
1_'
------解决方案--------------------------------------------------------
(select engname from param_ccypair where a.ratecode = CCYPAIRID and a.termid = 1 and engname like '%USD%')
------解决方案--------------------------------------------------------
'_O/N'
------解决方案--------------------------------------------------------
'_ASK
------解决方案--------------------------------------------------------
-
------解决方案--------------------------------------------------------
1_'
------解决方案--------------------------------------------------------
select engname from param_ccypair where a.ratecode = CCYPAIRID and a.termid = 1 and engname like '%USD%')
------解决方案--------------------------------------------------------
'_T/_ASK
------解决方案--------------------------------------------------------
' ,
askformula = '0-
------解决方案--------------------------------------------------------
1_'
------解决方案--------------------------------------------------------
select engname from param_ccypair where a.ratecode = CCYPAIRID and a.termid = 1 and engname like '%USD%')
------解决方案--------------------------------------------------------
'_O/N'
------解决方案--------------------------------------------------------
'_BID
------解决方案--------------------------------------------------------
-
------解决方案--------------------------------------------------------
1_'
------解决方案--------------------------------------------------------
select engname from param_ccypair where a.ratecode = CCYPAIRID and a.termid = 1 and engname like '%USD%')
------解决方案--------------------------------------------------------
'_T/N_BID
------解决方案--------------------------------------------------------
';