16.10 - SHOW CONTROLS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.

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