Using the "on-error-stop" Option in ACT - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

The “on-error-stop” option can be used to stop ACT if an error occurs while running queries. It discontinues executing the multi-statement SQL or the SQL file.

When the “on-error-stop” option is set, ACT halts query processing and exits as follows:

  • If ACT is in interactive mode, it returns to the ACT prompt when it encounters an error.
  • If ACT is executed in the command line, it exits with status 3 when it encounters an error.
Unless the-f or -c options are used, ACT is always in interactive mode once it is launched. The \set command can be used at the command line at any time. For more details on the \set syntax for the “on-error-stop” option, see Setting Database Parameters.