HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

SET EXIT_ON_DBERR ON 

Causes SQLGEN in batch operation to terminate immediately when an SQL
error is encountered.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> SET EXIT_ON_DBERR ON

Description 

   *   After you issue this command, the system JCW is set to FATAL if an
       SQL error is encountered or to 0 if no SQL errors are encountered.

   *   See the "DBA Tasks and Tools" chapter of this manual for
       information on checking JCWs when SQLGEN terminates.

   *   By default, SQLGEN does not terminate when an SQL error is
       encountered.

Example 

     >> SET EXIT_ON_DBERR ON 

MPE/iX 5.5 Documentation