Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2007 @ 16:19:58 GMT

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

Subj:   Re: Inconsistent Behavior of SQL passed through ODBC connection.
From:   Barry Hull

To keep your comments, you must use the "multiple footprint" execution option in SQL Assistant. The "single footprint" execution option will strip your comments. This is documented in later releases (this is from a TTU 8.1 SQL Assistant manual):

Execute Parallel Command With the Execute Parallel command, Teradata SQL Assistant will only remove comments that are found before the start of the first statement. All other comments will be transmitted to the database as part of your query.

Note: The ODBC driver might remove your comments if the Allow use of ODBC SQL extensions check box is selected. To see the status of this check box, select Tools > Options, then select the Query tab.

There is also a section in Appendix C of the SQL Assistant manual (for TTU 8.1) that talks about how to change the registry so that comments are not dropped.

I don't know if it works this way on your release, but you might want to try it.

  <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