HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix G SQLGEN

SET EXIT_ON_DBERR ON

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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" SECT 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


Feedback to webmaster