17.10 - DUL Commands - 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)

DUL Command Syntax

Unless otherwise specified, a DUL command must either begin with a period or end with a semicolon, and it can do both:

{ [.] dul_command |
  dul_command [;] |
  [.] dul_command [;]
}

For example, these are equivalent:

.SHOW VERSIONS
SHOW VERSIONS ;
.SHOW VERSIONS ;

dul_command is a command in either table in the following section.

Syntax for individual DUL commands does not include the period or semicolon.

DUL Command Categories

Dul commands are divided into the following two categories:
  • Session Control
  • Data Handling

The following table summarizes the functions of the session control commands.

Command Function
ABORT Aborts a LOAD or UNLOAD command.
DATABASE Changes the default database.
HELP Displays information about dul commands and dump databases.
LOGOFF or END or QUIT Ends a Vantage session and exits the dul utility. The END and QUIT commands are synonyms of LOGOFF.
LOGON Begins a Vantage session.
.OS Submits a command to your host operating system.
SHOW VERSIONS Displays dul software module release versions.
SHOW CONTROLS Displays the current user-configurable settings.

The following table summarizes the functions of the data handling commands.

Command Function
DROP Removes a dump table from the database.
LOAD Moves dump data from removable media to a Teradata system.
NOSPOOL Uses NOSPOOL feature of the database to dump the crashdump table.
SEE Reports statistics about the contents of a dump.
SELECT Sets selection criteria.
UNLOAD Moves dump data from a table on the database to a file on the host.
MULTIFILE Instructs DUL to generate or read from multiple split files of defined size during an UNLOAD or LOAD operation respectively.