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