Purpose
The SHOW CONTROLS command displays the current user-configurable settings.
Syntax
SHOW { CONTROLS | CONTROL } ;
Usage Notes
The SHOW CONTROLS command displays the current settings that has been used for the LOAD/UNLOAD operation.
The SHOW CONTROLS command gives current settings for:
- File Compression option
- NoSpool option
- Multifile option
- Current default database
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.