Archives of the TeradataForum
Message Posted: Fri, 16 Jul 2004 @ 17:17:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|