17.10 - SHOW CONTROLS - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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 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.