SET

The SET command lets you specify the following operating parameters for SQLUtil: BACKUP, EXIT_ON_DBERR, and ECHO_ALL.

Scope

SQLUtil only.

SQLUtil Syntax

>> SET [ BACKUP [ALLBASE] ECHO_ALL { ON OFF } EXIT_ON_DBERR { ON OFF } ]

Parameters

BACKUP ALLBASE: Specifies the use of the default ALLBASE/SQL backup software. This is the default setting.
ECHO_ALL: Causes SQLUtil to echo all input. The initial default setting is OFF.
EXIT_ON_DBERR: Causes SQLUtil to terminate immediately when a DBERR is encountered. The initial default setting is OFF.

Description

Issuing a SET BACKUP command sets the backup type to the default, that is, ALLBASE.
NOTE: Support for OMNIBACK was removed from ALLBASE/SQL.
When the ECHO_ALL command option is ON, batch user input is echoed to the standard output. The initial default setting is OFF.
Setting the EXIT_ON_DBERR to ON causes immediate termination of SQLUtil when an ALLBASE/SQL error is encountered.
See the "DBA Tasks and Tools" chapter of this manual for information on checking the exit status when SQLUtil terminates.
Issuing a SET command without parameters displays the current settings, exactly as in the SHOWSET command.

Authorization

Anyone can use this command.

Example

   >> set echo_all on

   >> set exit_on_dberr on

   set exit_on_dberr on



   >> set backup ALLBASE

   set backup ALLBASE



   >> SET

   set

          ECHO_ALL         :  ON

          EXIT_ON_DBERR    :  ON

   BACKUP:

          ALLBASE          :  ON

   >>

SET

Technical documentation

» Table of Contents