Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Feb 2007 @ 20:54:37 GMT

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

Subj:   Re: Inconsistent Behavior of SQL passed through ODBC connection.
From:   Dempsey, Mike

I think this has been answered already, but in case the answer was not detailed enough...

Queryman / SQL Assistant used to remove comments from queries (in all versions prior to 7.2) before executing a query.

You could avoid this by using 'Execute Parallel', but that would impose some restrictions on your query. (The entire query would be executed as a single request so it could not include DDL unless it was just a single DDL statement.) In addition, if any comments existed BEFORE the statement they would be removed.

In version 7.1 a registry entry was added. ('RemoveComments') This defaults to 'ffffffff'x (True) but if you set it to 0 (False) your comments would no longer be removed.

The downside is that if you enter a semi-colon anywhere other than as a statement delimiter (eg. in a comment or string) then your query will fail.

Starting in SQL Assistant 7.2 comments are no longer removed.

Note also that if you use the option 'Allow use of ODBC SQL Extensions' it is possible that some versions of the ODBC driver will remove your comments also.

Mike Dempsey
Teradat Client Tools

  <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: 28 Jun 2020