5509 Global temporary table cannot be created WITH DATA.
Explanation:
If GLOBAL TEMPORARY is specified in a CREATE TABLE statement, only the definition of the base temporary table is created. A temporary table for data storage is materialized only when the user references the base temporary table, so 'WITH DATA' may not be specified for global temporary tables.
Generated By:
Syntaxer.
For Whom:
User.
Remedy:
Change 'WITH DATA' to 'WITH NO DATA' and re-submit query.