  | 
»  | 
 | 
  
 | 
 | 
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:
 
- 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:
   
   >>
 |  
  
 |