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