NOSTOP

Restriction: This topic applies to Windows environments only.

This batch SQL command instructs the system to process errors without pausing for user acknowledgment.

The syntax is:

NOSTOP;

The NOSTOP command must be placed immediately after the query on which you want it to start taking effect. Once a NOSTOP command is executed, it will remain in effect for the rest of the script, or until a ERRSTOP command is encountered. Together, the ERRSTOP and NOSTOP commands can be used to selectively enable or disable error processing at certain points in the batch file.

For example:

UPDATE employee
SET com = 0
WHERE dept = "2020";
NOSTOP;          --Do not stop on error
UPDATE customer SET balance=0 
WHERE balance > 0;
ERRSTOP;          --Stop on error

This example directs the system to ignore errors that occur when updating the EMPLOYEE table, but to stop on errors that occur when updating the CUSTOMER table.