5,889
社区成员
发帖
与我相关
我的任务
分享
DECLARE GLOBAL TEMPORARY TABLE SESSION.LASTTIME
( CONTINUUMID VARCHAR(15),
MAXTIME TIMESTAMP )
WITH REPLACE
NOT LOGGED;
SET sqlStr1 = 'INSERT INTO SESSION.LASTTIME(CONTINUUMID,MAXTIME) SELECT HNM_TR_SITEANDCONID.CONTINUUMID,
value(MAX(STATISTIC_DATE),timestamp((current timestamp)-1 DAY))
FROM '||newTableName||'
right JOIN HNM_TR_SITEANDCONID
ON HNM_TR_SITEANDCONID.CONTINUUMID = '||newTableName||'.CONTINUUMID
group by HNM_TR_SITEANDCONID.CONTINUUMID';
EXECUTE IMMEDIATE sqlStr; --
INSERT INTO SESSION.LASTTIME(CONTINUUMID,MAXTIME) SELECT HNM_TR_SITEANDCONID.CONTINUUMID,
value(MAX(STATISTIC_DATE),timestamp((current timestamp)-1 DAY))
FROM newTableName
right JOIN HNM_TR_SITEANDCONID
ON HNM_TR_SITEANDCONID.CONTINUUMID = newTableName.CONTINUUMID
group by HNM_TR_SITEANDCONID.CONTINUUMID