Embedded Usage
In an embedded CREATE TABLE statement:
• Host language variables can be used to specify constant expressions in the subselect of a CREATE TABLE...AS SELECT statement.
• Location_name can be specified using a host language string variable.
• The preprocessor does not validate the syntax of the with_clause.