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