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

SHOWSET

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Displays the setting of a parameter established with the SET command.

Scope

SQLUtil Only.

SQLUtil Syntax

>> SHOWSET [ BACKUP ECHO_ALL EXIT_ON_DBERR ]

Parameters

BACKUP

is the name of the Backup setting established with the SET command.

Possible parameters:

  • STORESET

  • RESTORESET

  • MOSET

ECHO_ALL

is the ECHO_ALL setting established with the SET command. Possible values are ON or OFF.

EXIT_ON_DBERR

is the EXIT_ON_DBERR setting established with the SET command. Possible values are ON or OFF.

Description

  • The SHOWSET command displays the current value of the BACKUP, ECHO_ALL, or EXIT_ON_DBERR setting.

  • If you issue the SHOWSET command without specifying an additional parameter, SQLUtil displays settings for all parameters that are set with the SET command.

Example

   >> set echo_all on

   >> showset echo_all

   showset echo_all

          ECHO_ALL         :  ON



   >> set backup storeset '(*TAPE1, *TAPE2)'

   >> showset backup

   showset backup

          STORESET     option:  (*TAPE1, *TAPE2)

          RESTORESET   option: 

          MOSET        option:

   

   >>


Feedback to webmaster