db2 substr-current的使用

select case bigsmall.bankno 
when '102' then '工商银行'
when '103' then '农业银行'
when '104' then '中国银行'
when '105' then '建设银行'
when '301' then '交通银行'
when '302' then '中信银行'
when '303' then '光大银行'
when '304' then '华夏银行'
when '308' then '招商银行'
when '309' then '兴业银行'
when '310' then '上海浦东发展银行'
when '319' then '徽商银行'
when '403' then '邮政储蓄银行'
else bigsmall.bankno end as 银行 , sum(bigsmall.sumamt) as 来账金额 
from
(
select substr(s_sndreckbnkno,1,3) as bankno,sum(f_amt) as sumamt, 'big' as type  from ta_big_come_index 
where d_accept=to_char(current date - 1 days,'yyyy-mm-dd') and s_msgtypeno in ('100','103','108')
group by substr(s_sndreckbnkno,1,3) 
union all
select substr(s_sndreckbnkno,1,3) as bankno,sum(f_amt) as sumamt, 'small' as type  from ta_small_come_index 
where D_PKGENTRUST =to_char(current date - 1 days,'yyyy-mm-dd') and S_PKGTYPENO in ('001','002','007','008')
group by substr(s_sndreckbnkno,1,3)
) as bigsmall group by bigsmall.bankno having bigsmall.bankno in ('102','105','104','103','301','308','403','309','319','310','302','304','303')
order by sum(bigsmall.sumamt) desc