Archives of the TeradataForum
Message Posted: Tue, 02 May 2006 @ 14:44:46 GMT
If you use execute parallel neither type of comments will be removed from the query by SQL Assistant.
It is possible that some comments are removed by the ODBC driver if you have the last checkbox on the Query tab of Options checked however. (Allow use of ODBC SQL Extensions)
It is however true that you can not use Execute parallel if the query contains any statements after a DDL statement. (So you can not submit a query containing 2 Create View statements for example.)
Currently the only way around this is to add a value to the registry. This will work only with SQL Assistant 7.1 and above.
1) Use RegEdit to open the following registry key:
2) Then add a new DWORD value:
Let it default to a value of zero.
Warning - if you do this you must never use a ';' in any comment.
SQL Assistant 7.2 will not remove any comments... but is not yet generally available.
Quotes in comments have also been known to confuse the application under certain circumstances. Newer versions are better than older ones in this area, and version 7.2 will finally correct all such problems. (But will not be available until later this year.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|