How the StaticBinder handles DECLARE GLOBAL TEMPORARY TABLE statements

The DDL statement DECLARE GLOBAL TEMPORARY TABLE is bound and run statically like captured SQL DML statements.

Declared global temporary tables are application-specific, have no persistent record in the system catalog, and do not persist after the applications that contain their declaration stop. During the DB2® bind operation, all SQL statements that contain references to any declared global temporary tables are not fully bound, but instead are incrementally bound at run time. Therefore, no additional negative impact is caused during run time by the presence of the DECLARE GLOBAL TEMPORARY TABLE statement.


Feedback