Temporary Table Restrictions
Temporary tables are subject to the following restrictions:
• A temporary table cannot be used within a database procedure. It can, however, be used as an input parameter to a database procedure if it is the only parameter and the procedure is not row producing.
• A temporary table cannot be used in a view definition.
• Integrities, constraints, or user-defined defaults cannot be created for temporary tables. (The with|not null and with|not default can be specified.)
• A temporary table cannot be modified to use a different page size.
• Repeat queries referencing temporary tables cannot be shared between sessions.
• A temporary table cannot be partitioned.
All SQL statements can be used with temporary tables except the following:
• ALTER TABLE
• COMMENT ON
• CREATE INTEGRITY
• CREATE PERMIT
• CREATE RULE
• CREATE SECURITY_ALARM
• CREATE SYNONYM
• CREATE VIEW
• GRANT
• HELP
• REVOKE
• SAVE
• SET JOURNALING
• SET LOCKMODE
The following commands cannot be issued with a temporary table name:
• auditdb
• copydb
• optimizedb
• statdump
• verifydb
• usermod
• genxml
• xmlimport