I'm running a script in SQL Assistant against Teradata without any errors and when I run the same script in TDP I encounter the following in the SQL editor. Teradata exception: [Teradata Database] [3704] ' ' ('C2A0'X) is not a valid Teradata SQL token. The issue is with the case statement. If the…

TDP Character Conversion Error

toad.user April 17, 2020, 8:35pm 2

Found a solution. This appears to be specific to Teradata, but using an ODBC connection with the Enable Legacy Parser appears to solve the problem.

Topic		Replies	Views
Toad Data Point ODBC Issue Toad Data Point & Toad Intelligence Central	3	802	April 22, 2020
Error: [Teradata Database] [3704] 'š' ('A0'X) is not a valid Teradata SQL token. Toad Data Point & Toad Intelligence Central	4	8100	April 26, 2016
CSV Import Error Toad Data Point & Toad Intelligence Central	4	1365	December 17, 2019
TDP 3.8 - SQL errors with Teradata Toad Data Point & Toad Intelligence Central	1	765	February 1, 2017
Query Error In Toad Data Point 5.7 Toad Data Point & Toad Intelligence Central	5	650	December 16, 2022