DB2的临时表建立(CGTT)
1 Create GLOBAL TEMPORARY TABLE <table_name> (
2 <column_name> <column_datatype>,
3 <column_name> <column_datatype>,
4 … )
5 ON COMMIT [PRESERVE|DELETE] ROWS
6 [NOT LOGGED|LOGGED] ON ROLLBACK [PRESERVE|DELETE] ROWS
7 DISTRIBUTE BY HASH ( col1,..)
8 IN <tspace-name>;
9
2 <column_name> <column_datatype>,
3 <column_name> <column_datatype>,
4 … )
5 ON COMMIT [PRESERVE|DELETE] ROWS
6 [NOT LOGGED|LOGGED] ON ROLLBACK [PRESERVE|DELETE] ROWS
7 DISTRIBUTE BY HASH ( col1,..)
8 IN <tspace-name>;
9
posted on 2011-07-27 22:22 gongwei911 阅读(3600) 评论(0) 编辑 收藏 举报
