Restrictions on Temporary Tables
Temporary tables are subject to the following restrictions:
• Temporary tables cannot be used within database procedures.
• Temporary tables cannot be used in view definitions.
• You cannot create integrities, constraints, or user-defined defaults for temporary tables. (You can specify with | not null and with | not default.)
• The following SQL statements cannot be used on temporary tables:
– create index
– create permit
– create synonym
– create view
– grant
– revoke
– save
– set journaling
– set lockmode
– create security_alarm
– help
– create integrity
– create rule
All other SQL statements can be used with temporary tables.
• Repeat queries referencing temporary tables cannot be shared between sessions. Any session can create temporary tables and no locking is performed.
For more information, see the following statement descriptions: