Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Jul 2005 @ 15:01:36 GMT


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


Subj:   Re: SQL Assistant 7.0 with ODBC 3.04
 
From:   Victor Sokovin

  With SQL Assistant: If you DONT need comments (reduces network usage) then use 'Execute'. If you DO want to keep the comments then use 'Execute Parallel'.  


  This is well documented in the Help/User Guide.  


It is indeed. The manual also seems to suggest that some versions of the ODBC driver might remove comments if the ODBC extensions are allowed in the SQLA options.

I think all this refers to the /* ... */-style comments. ANSI (--) comments are less likely to survive in SQLA, right?


  The only exceptuion to this is that if you enter comments BEFORE the start of the SQL then those comments will always be removed. (This is required due to a problem in the ODBC driver where column headers are not returned when comments preceed the SQL. [A problem recently refered to on this forum when using Teradata Administrator - which does not remove these comments])  


Here is the reference:

www.teradataforum.com/teradata/20050708_201726.htm .


Regards,

Victor



     
  <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: 15 Jun 2023