8. SQL Statements : DECLARE GLOBAL TEMPORARY TABLE : Embedded Usage
 
Share this page                  
Embedded Usage
In an embedded DECLARE GLOBAL TEMPORARY TABLE statement:
Host language variables can be used to specify constant expressions in the subselect of a CREATE TABLE...AS statement.
Locationname can be specified using a host language string variable.
The preprocessor does not validate the syntax of the WITH clause.
Do not specify the DECLARE GLOBAL TEMPORARY TABLE SESSION statement within the DECLARE section of an embedded program. Place the statement in the body of the embedded program.