Temporary tables support LOB-type columns

In Version 9.7, declared temporary tables can contain LOB-type columns. LOB-type columns are also supported for created temporary tables.

Prior to Version 9.7, you could not store LOB data in declared temporary tables, so applications either had to work around not having the LOB data in a declared temporary table or had to use a regular table.

For both types of user-defined temporary tables, the values for LOB-type columns are stored in the same table space in which the temporary table is instantiated.