SELECT msgid, msgtitle msg, CASE WHEN msgtext IS NULL THEN msgtitle ELSE msgtext END title, 'loan.sysman.infoboard.publicinfo.select' serviceid, CASEWHEN {d '2012-01-19'} - issudate
显示全部SELECT
msgid,
msgtitle msg,
CASE
WHEN msgtext IS NULL THEN msgtitle
ELSE msgtext
END title,
'loan.sysman.infoboard.publicinfo.select' serviceid,
CASE
WHEN {d '2012-01-19'} - issudate <= 7 THEN '1'
ELSE '0'
END isnew
FROM
xd_sys_comm_msginfo
WHERE
{d '2012-01-19'} - issudate <= keepterm
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
控制中心执行正常
收起