HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 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.

  • The 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