Applications can create and use temporary tables for the duration of the database connection.
Temporary table are externalized to the user for use as a table that is accessible via SQL, but which is only available to the application that creates it and doesn't persist beyond the application's connection to the database. With savepoint support, an application can use named savepoints within a transaction, data or schema changes as savepoint can be undone without affecting the overall outcome of the transaction. A compound SQL statement allows users to group several SQL statements into a single executable block. In an atomic compound SQL statement, an implicit compound SQL savepoint is taken prior to executing the first sub-statement of the block. If any of the sub-statements end in an error, the entire block is considered to end in an error and rolls back to the compound SQL savepoint.