Archives of the TeradataForum
Message Posted: Tue, 26 Jul 2005 @ 15:01:36 GMT
| 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
| 
