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
[解决办法]
';
