可变临时表

创建一个可变临时表的脚本：

CREATE VOLATILE TABLE vt_deptsal, LOG
(deptno SMALLINT
,avgsal   DEC(9,2)
,maxsal   DEC(9,2)
,minsal   DEC(9,2)
,sumsal   DEC(9,2)
,empcnt   SMALLINT)
ON COMMIT PRESERVE ROWS; 

 

查询相关信息：

HELP VOLATILE TABLE; 

 可变临时表的宏：

CREATE MACRO vt1 AS (SELECT * FROM vt_deptsal;);