•In regards to temporary tables in the database, always DISCONNECT and then CONNECT before using the AUTOCHK, PACK, or RELOAD commands.
•Temporary tables/views are support in read-only structure (STATICDB is ON) environments.
•When creating a temporary table/view, the following temporary system tables are also created:
oSYSTMP_COMMENTS
oSYSTMP_CONSTRAINTS
oSYSTMP_DEFAULTS
oSYSTMP_RULES
oSYSTMP_SERVERS
oSYSTMP_TRIGGERS
oSYSTMP_VIEWS
•Temporary tables/views were first introduced in R:BASE 6.1 (July 1997).