Tags for disable parsing
Problems with NoScan parameter
Hi,   I'm facing SQL error "Syntax error, expected something like an 'IN' keyword or a 'CONTAINS' keyword between ')' and '|'." when run statement: DELETE FROM  aidar.time_ansi  a WHERE (         a."id_1"           ) IN (         SELECT              cast(substr(rk_1,11) as INTEGER) k_1
NoScan disable parsing SQL error
Teradata V13 and Comments
Hello! We have a process whereby user queries require "approving" or "rejecting" when accessing sensitive customer data. In order to make the process run more smoothly we ask that users comment their queries to pass a note for the reviewer: SELECT Top 100 * /* Project Projectname Analysis Q1 */ FROM databasename.tablename ; What we are finding with ODBC connectivity is that the comments are stripped out before reaching Teradata. If we set the option Disable Parsing in the ODBC options, the comments remain in the query and this is the workaround we are following.
odbc sql comment disable parsing