16.10 - DUL Commands - 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

DUL Command Syntax

Dul commands must either begin with a period or be terminated with a semicolon. They also can use both, as shown below:

.SHOW VERSIONS
SHOW VERSIONS ;
.SHOW VERSIONS ;

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 Teradata Database session and exits the dul utility. The END and QUIT commands are synonyms of LOGOFF.
LOGON Begins a Teradata Database 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 Teradata Database.
LOAD Moves dump data from removable media to a Teradata Database 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 Teradata 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.