The SHOW CONTROLS command displays the user-configurable settings.
The user-configurable settings are:
- File Compression option
- NoSpool option
- Multifile option
- Current default database
Syntax
SHOW { CONTROLS | CONTROL } ;
Example: Displaying the values of user-configurable settings
To display the current dul settings:
.SHOW CONTROLSThe following appears:
*** File Compression Enabled. *** NoSpool option OFF. *** Multifile option ON. Maximum split file size is 2097152000 bytes. *** Current default database is crashdumps.