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.