Actian X 11.2 | DECLARE GLOBAL TEMPORARY TABLE Examples

SQL Reference Guide > SQL Reference Guide > SQL Statements > DECLARE GLOBAL TEMPORARY TABLE > DECLARE GLOBAL TEMPORARY TABLE Examples

Was this helpful?

DECLARE GLOBAL TEMPORARY TABLE Examples

1. Create a temporary table.

EXEC SQL DECLARE GLOBAL TEMPORARY TABLE
    emps
    (name CHAR(20) , empno CHAR(5))
    ON COMMIT PRESERVE ROWS
    WITH NORECOVERY,
    LOCATION = (personnel),
    NODUPLICATES,
    ALLOCATION=100,
    EXTEND=100;

2. Use a subselect to create a temporary table containing the names and employee numbers of the highest-rated employees.

EXEC SQL DECLARE GLOBAL TEMPORARY TABLE
    emps_to_promote
    AS SELECT name, empno FROM employees
    WHERE rating >= 9
    ON COMMIT PRESERVE ROWS
    WITH NORECOVERY

Last modified date: 04/26/2024