You cannot use the following features with temporary tables:

• Synonyms, triggers and views on SESSION schema tables (including physical tables and temporary
         tables)
• Caching statements that reference SESSION schema tables and views
• Temporary tables cannot be specified in referential constraints and primary keys
• Temporary tables cannot be referenced in a triggered-SQL-statement
• Check constraints on columns
• Generated-column-spec
• Importing into temporary tables

If a statement that performs an insert, update, or delete to the temporary table encounters an error, all the rows of the temporary table are deleted.

The following data types cannot be used with Declared Global Temporary Tables:

• BLOB
• CHAR FOR BIT DATA
• CLOB
• LONG VARCHAR
• LONG VARCHAR FOR BIT DATA
• VARCHAR FOR BIT DATA
• XML