Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Feb 2013 @ 20:01:59 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Error : 3704: "0A"X not a valid Teradata SQL
From:   Dempsey, Mike

I assume you are using SQLA or higher.

Prior to this version SQLA used to remove '0A'x characters from all queries - because they sometimes used to cause Teradata problems.

In this version we stopped removing it from most queries because it would sometimes remove that character from within a string - where it was allowed/required.

We now remove it only from Create/Replace statements - to avoid problems with comparisons to existing DDL.

Maybe this is a cut/paste problem, but your query is not valid. At the very least a ')' is missing from the end. You would get a syntax error from SQLA if that character was missing - not the error you reported.

If I add the ')' character the query runs fine in SQLA, so either there is a strange character embedded in your query that was lost during Cut/Paste into this email, or there is additional text in the Query. (in addition to the missing ')')

Mike Dempsey

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020