Examples

Example 1: Define a declared temporary table with column definitions for an employee number, salary, commission, and bonus.

   DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_EMP
     (EMPNO    CHAR(6)     NOT NULL,
      SALARY    DECIMAL(9, 2),
      BONUS     DECIMAL(9, 2),
      COMM      DECIMAL(9, 2))
     ON COMMIT PRESERVE ROWS

Example 2: Assume that base table USER1.EMPTAB exists and that it contains three columns, one of which is an identity column. Declare a temporary table that has the same column names and attributes (including identity attributes) as the base table.

   DECLARE GLOBAL TEMPORARY TABLE TEMPTAB1
     LIKE USER1.EMPTAB
     INCLUDING IDENTITY
     ON COMMIT PRESERVE ROWS

In the above example, the database manager uses SESSION as the implicit qualifier for TEMPTAB1.