DB2常用函数
a.DATE_INSTAL like substr('20190508',1,6)||'%' and
round(ent_to_psn_binum*100.00/all_binum,2)==83.35保留2位小数
LENGTH(NAME) 求字段值长度
nvl(IOU_AMT,0) 金额为空时为零
lower()转小写
value(id,'d'),id不空,返回ID,id为空,返回第二个参数的值
CAST(NAME AS VARCHAR(10)) as name
cast(GONGZI as decimal (20,3))
cast(id as int)
取余
mod(age,5)=0,<==>age%5=0
mod(TRN_AMT,10)=6
substr('#ETL_DT#',1,4)=2019,ETL_DT="20190908"
CASE WHEN EXT_DT LIKE substr('#ETL_DT#',1,4)||'%' THEN 'Y' ELSE 'N' END
replace('abcd','a','111')='111bcd'
查看DB2版本
select service_level
from sysibmadm.env_inst_info
重命名表
rename table tda.T_QNJF_CUST_INFO_LOAN to T_QNJF_CUST_LOAN_JFINFO_ADD
清除表数据
truncate table FCT.FCT_QNYP_CUST_SAVING_DEP_HZ IMMEDIATE
2021-7-21