%db2 update TB_GCMX_SF set tt=case when substr('tl',2,2)='GJ' then '010' when substr('tl',2,2)='DD' then '020' when substr('tl',2,2)='VB' then '030' when substr('tl',2,2)='CH' then '040' when substr('tl',2,2)='NK' then '050' when substr('tl',2,2)='SF' then '060' when substr('tl',2,4)='MLSF' then '070' else '' end where ts='$bh$' #
从DB2传数据到ORA ,在配置文件中,这句话该如何来实现呢?
按上面的写法当substr('tl',2,4)='MLSF' 总是得不到正确的结果'070', 总是得了'060'
%db2 update TB_GCMX_SF set tt=case when (substr('tl',2,2)='GJ' and substr('tl',2,4)'MLSF' ) then '010' when (substr('tl',2,2)='DD'and substr('tl',2,4)'MLSF' )then '020' when (substr('tl',2,2)='VB' and substr('tl',2,4)'MLSF' )then '030' when (substr('tl',2,2)='CH'and substr('tl',2,4)'MLSF' )then '040' when (substr('tl',2,2)='NK' then '050' and substr('tl',2,4)'MLSF' ) when (substr('tl',2,2)='SF'and substr('tl',2,4)'MLSF' ) then '060'else ' 070' end where ts='$bh$' #
这样写为什么也是不行呢?
|