15.00 - SHOW CONTROLS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SHOW CONTROLS

Purpose  

The SHOW CONTROLS command displays the current user-configurable settings.

Syntax  

Usage Notes  

The SHOW CONTROLS command displays the current settings that has been used for the LOAD/UNLOAD operation.

For DUL, the SHOW CONTROLS command gives current settings for:

  • File Compression option
  • NoSpool option
  • Multifile option
  • Current default database
  • For DULTAPE, the SHOW CONTROLS command gives current settings for:

  • NoSpool option
  • Current default database
  • Example  

    To display the current DUL/DULT settings:

    .SHOW CONTROLS

    The following appears:

    *** File Compression Enabled.
    *** NoSpool option OFF.
    *** Multifile option ON.
     Maximum split file size is 2097152000 bytes.
    *** Current default database is crashdumps.