SQL语句变换
SQL语句转换
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
------解决方案--------------------
';
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
------解决方案--------------------
';