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

SET EXIT_ON_DBERR

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Allows you to terminate or continue execution when a database error occurs.

Scope

SQLAudit only.

SQLAudit Syntax

SE[T]EXIT[_ON_DBERR] { OFF ON } SE [T] EXIT [_ON_DBERR] Option setting (OFF/ON) >> { OFF ON }

Description

  • When EXIT_ON_DBERR is set to ON, SQLAudit terminates execution when a database error is encountered.

  • When EXIT_ON_DBERR is set to OFF, SQLAudit continues execution when a database error is encountered.

  • he default setting for this option is OFF (continue execution if a database error occurs).

Authorization

Anyone can issue the SET EXIT_ON_DBERR command.

Example

   SQLAudit >> set exit_on_dberr on





   SQLAudit >> set exit_on_dberr



   Option Setting (OFF/ON) >> on



   SQLAudit >>


Feedback to webmaster