Example: CREATE TABLE AS Statement Contains Special Characters - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantageā„¢

In this example, the CREATE TABLE AS statement contains special characters in the pivot query IN list.

CREATE TABLE t1 AS 
(SELECT *
FROM s1 PIVOT (SUM(sales) FOR mon IN (U&"#FAD7" UESCAPE '#')) tmp ) WITH DATA;

*** Failure 4306 Invalid PIVOT query: Unsupported In-List Values/Expressions.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.