Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

Analytics

Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

Execution of a Win Demo TD (8.1) stored procedure using JDBC gives the following error-
'{' ('7B'X) is not a valid Teradata SQL token.

There is neither such token in the stored proc file nor in the table that is being used for dynamic value input.

Though I saw a similar post with the invalid token as {'OA'X) instead of '7B'X, am at wits end trying to debug this one. Any input will be highly appreciated!

Thanks,
Kabir
4 REPLIES

Re: Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

I was accessing the TD database via JDBC and the JDBC driver was incorrect. After moving to a new version (one with this specific error corrected), the stored procedure worked just fine.

Regards,
Taher
Enthusiast

Re: Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

just check if one of brackets are missing eg . in ${xyz}, { or } might be missing
Enthusiast

Re: Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

Some times comments might contain special characters like ' or " TD Syntaxer acts little funny some times. Same sql works fine in BTEQ.
New Member

Re: Facing error- '{' ('7B'X) is not a valid Teradata SQL token.

hi,

ı meet same problems . You should change data provider as ODBC in sql assistant .

 

good luck

yusuf