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

DUL Commands

DUL Command Syntax

Dul and dultape 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 each dul command.

     

    Activity

    Command

    Function

    Operating System

    Session Control

    “ABORT”

    Aborts a LOAD or UNLOAD command.

    All

     

    “DATABASE”

    Changes the default database.

    All

     

    “HELP”

    Displays information about dul commands and dump databases.

    All

     

    “LOGOFF”
    “END”
    “QUIT”

    Ends a Teradata Database session and exits the dul utility. The END and QUIT commands are synonyms of LOGOFF.

    All

     

    “LOGON”

    Begins a Teradata Database session.

    All

     

    “.OS”

    Submits a command to your host operating system.

    All

     

    “SHOW TAPE”

    Lists the files on the tape.

    All

     

    “SHOW VERSIONS”

    Displays dul software module release versions.

    All

     

    “SHOW CONTROLS”

    Displays the current user-configurable settings.

    All

    Data Handling

    “DROP”

    Removes a dump table from the Teradata Database.

    All

     

    “LOAD”

    Moves dump data from removable media to a Teradata Database system.

    All

     

    “NOSPOOL”

    Uses NOSPOOL feature of the database to dump the crashdump table.

    ALL

     

    “SEE”

    Reports statistics about the contents of a dump.

    All

    Data Handling
    (continued)

    “SELECT”

    Sets selection criteria.

    All

     

    “UNLOAD”

    Moves dump data from a table on the Teradata Database to a file on the host.

    All

     

    “MULTIFILE”

    Instructs DUL to generate or read from multiple split files of defined size during an UNLOAD or LOAD operation respectively.

    All