DB2中创建一个获取汉字拼音首字母的SQL函数

利用sql语句生成一组上述汉字的结果集，我们将’i’,’u’,’v’ 三个空缺汉字的位置补上了上一个拼音的汉字，

select t1.strChn
from ( select ’澳’ strChn from sysibm.sysdummy1
union all
select ’怖’ strChn from sysibm.sysdummy1
union all
select ’错’ strChn from sysibm.sysdummy1
union all
select ’堕’ strChn from sysibm.sysdummy1
union all
select ’贰’ strChn from sysibm.sysdummy1
union all
select ’咐’ strChn from sysibm.sysdummy1
union all
select ’过’ strChn from sysibm.sysdummy1
union all
select ’祸’ strChn from sysibm.sysdummy1
union all
select ’祸’ strChn from sysibm.sysdummy1
union all
select ’骏’ strChn from sysibm.sysdummy1
union all
select ’阔’ strChn from sysibm.sysdummy1
union all
select ’络’ strChn from sysibm.sysdummy1
union all
select ’穆’ strChn from sysibm.sysdummy1
union all
select ’诺’ strChn from sysibm.sysdummy1
union all
select ’沤’ strChn from sysibm.sysdummy1
union all
select ’瀑’ strChn from sysibm.sysdummy1
union all
select ’群’ strChn from sysibm.sysdummy1
union all
select ’弱’ strChn from sysibm.sysdummy1
union all
select ’所’ strChn from sysibm.sysdummy1
union all
select ’唾’ strChn from sysibm.sysdummy1
union all
select ’唾’ strChn from sysibm.sysdummy1
union all
select ’唾’ strChn from sysibm.sysdummy1
union all
select ’误’ strChn from sysibm.sysdummy1
union all
select ’迅’ strChn from sysibm.sysdummy1
union all
select ’孕’ strChn from sysibm.sysdummy1
union all
select ’座’ strChn from sysibm.sysdummy1
) as t1