oracle和db2兼容问题
select * from TDA_ARCHIVE a where (select to_number(to_char(sysdate,'yyyy'))-to_number(to_char(a.CREATE_DATE,'yyyy')) from dual)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID

如何改为兼容as400 db2？

[解决办法]
帮你顶起，学习一下
[解决办法]
select * from TDA_ARCHIVE a where (select year(current date) - yeaer(a.CREATE_DATE) from sysibm.sysdummy1)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID
[解决办法]
DB2直接用YEAR，表用1个系统表OR 已经存在的任意表，假设任意表为TT
select * from TDA_ARCHIVE a where (select DISTINCT year(current date) - yeaer(a.CREATE_DATE) from TT)>(select code from TDM_ENUMITEM b where a.STORETERM_ID = b.ENUMID