The syntax of Teradata ARC control language is similar to Teradata SQL, that is, each statement is composed of words and delimiters and is terminated by a semicolon. Teradata ARC writes each statement (and a response to each statement) to an output file.
For simplified descriptions of the Teradata ARC control language, refer to the Archive/Recovery chapter of the Teradata Tools and Utilities Command Summary (B035-2401), which provides only syntax diagrams and a brief description of the syntax variables for each Teradata client utility.
The Teradata ARC control statements perform these types of activities:
- Session statements begin and end utility tasks
- Archive statements perform archive and restore activities, and build indexes
- Recovery statements act on journals, and rollback or rollforward database or table activity
Starting with TTU 15.10.00.00, the use of Permanent Journal tables is deprecated by the Teradata Archive/Recovery Utility. This includes all statements and options that are related to Journal tables that are mentioned in this Manual.