Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Nov 2006 @ 19:11:24 GMT


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


Subj:   Re: Dropping a table from sql assistant
 
From:   Dempsey, Mike

SQL Assistant processes only SQL.

The statements starting with a period are BTEQ specific statements - no other application will recognize them.

SQLA only allows 2 options

1) stop after the first error

2) ignore all errors and attempt to process each statement regardless. (Controled by the 'Stop query execution if an SQL error occurs' option on the Query tab of Options)


If you use SQLA with SQL Server however you will be able to execute scripts (like the one you mention) by pressing F9 or using the 'Execute Parallel' menu. In this case SQLA simply sends the entire script to SQL Server and allows its built-in script processor figure out the logic. Teradata DBS does not have a built-in script processor.


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