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.
The only possible parameter is ALLBASE.
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 ALLBASE
set backup ALLBASE
>> showset backup
showset backup
ALLBASE : ON
>>