Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 May 2006 @ 14:44:46 GMT


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


Subj:   Re: SQL Assistant comments problems
 
From:   Dempsey, Mike

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:

          HKEY_CURRENT_USER\Software\NCR\Queryman

2) Then add a new DWORD value:

          RemoveComments

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


Mike Dempsey
Teradata Client Tools



     
  <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: 23 Jun 2019