Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 16 Jul 2004 @ 17:17:14 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: If Exists Then ...Else ....
From:   Dempsey, Mike

Queryman (SQL Assistant) does not support any kind of procedural logic. (When connected to Teradata that is. You can use procedural scripts with SQLServer and some other databases by using the 'Execute Parallel' button.)

If you want to drop a table and then continue with other SQL (not caring if it was dropped, or simply didn't exist) you can clear the checkbox 'Stop query execution if an SQL error occurs' on the Query tab of the Options screen.

This tells Queryman to ignore the error (if the table did not exist) and simply continue with the rest of your script.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016