Archives of the TeradataForum

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

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

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>>