This file contains an example for each Teradata statement. This information can be viewed in the Favorites window, or within the Query Builder.
The file consists of one definition for each example. Each definition contains two parts and can span multiple lines in the file. The two parts are separated by the string ~|~ and the definition ends with the string |~|.
The first part is the statement keyword itself – possibly followed by text within parenthesis. This extra text is used when multiple examples are defined for a single statement.
The second part is the example itself. This will be displayed, and optionally inserted into a query, exactly as entered in this file.
CREATE DATABASE~|~CREATE DATABASE finance FROM ApplDb AS PERM = 2000000 SKEW = 100 SPOOL = 5000000 FALLBACK ACCOUNT= 'ACCTG' NO AFTER JOURNAL DUAL BEFORE JOURNAL DEFAULT JOURNAL TABLE = finance.journals;|~| DROP DATABASE~|~DROP DATABASE MyDb;|~| SELECT (Aggregate)~|~SELECT COUNT(employee) FROM Department WHERE DeptNo > 100 HAVING COUNT(employee) > 10 ;|~|