91. 建立彙總表 (MQT) - 類似 Oracle Materialized View
CREATE SUMMARY TABLE TBL_NAME AS (FULLSELECT) ...
DATA INITIALLY DEFERRED REFRESH DEFERRED
-- 範例: 可重新整理的彙總表
CREATE SUMMARY TABLE SUM_TBL AS (SELECT * FROM SRC WHERE COL1='AAA')
DATA INITIALLY DEFERRED REFRESH DEFERRED
DATA INITIALLY DEFERRED：建表時不載入資料。REFRESH DEFERRED：手動執行 REFRESH TABLE 更新。
92. 重新整理彙總表
REFRESH TABLE SUM_TABLE
93. 修改彙總表
ALTER TABLE SUM_TABLE ...
94. 建立全域暫存表 (DGTT)
DECLARE GLOBAL TEMPORARY TABLE TBL_NAME
AS (FULLSELECT) DEFINITION ONLY
EXCLUDING IDENTITY COLUMN ATTRIBUTES
ON COMMIT DELETE ROWS
NOT LOGGED
-- 範例
DECLARE GLOBAL TEMPORARY TABLE SESSION.DEC_EMP
AS (SELECT * FROM EMP) DEFINITION ONLY
EXCLUDING IDENTITY COLUMN ATTRIBUTES
ON COMMIT DELETE ROWS
NOT LOGGED
- 僅存在於當前 Session，
ON COMMIT DELETE ROWS：Commit 時清空資料。
NOT LOGGED：不寫日誌，效能佳。
95. 視圖管理
CREATE VIEW VIEW_NAME AS SELECT * FROM TABLE WHERE ...;
DROP VIEW VIEW_NAME;
-- 查看視圖定義
SELECT TEXT FROM SYSCAT.VIEWS WHERE VIEWNAME='VIEW_NAME'
96-97. 別名管理
CREATE ALIAS ALIAS_NAME FOR PRO_NAME; -- PRO_NAME 可為 TABLE/VIEW/ALIAS/NICKNAME
98-100. Sequence 完整管理
-- 建立
CREATE SEQUENCE SEQ_NAME
START WITH START_NUM
INCREMENT BY VAL
NO MAXVALUE
NO CYCLE
CACHE MAX_VALUES
-- 修改
ALTER SEQUENCE SEQ_NAME ... -- 可修改 START/INCREMENT/MAXVALUE/CYCLE/CACHE
-- 刪除
DROP SEQUENCE SEQ_NAME
101-104. 資料移動工具格式支援對照表
