FastExport Command Conventions - FastExport

The following are command conventions to observe in FastExport job scripts.

Conditional Expressions

Conditional expressions return a value of:

0 if the condition evaluates to FALSE

1 if the condition evaluates to TRUE

With the following exceptions, FastExport handles conditional expressions as described in the Teradata SQL reference documentation for the operating system environment:

The LIKE operator is not supported in logical expressions that make up a conditional expression. (The NOT IN operator is supported.)

The following elements are not supported in arithmetic expressions that make up logical expressions:

The exponential operator

Aggregate operators

Arithmetic functions

Operators

Do not use words that are logical operators as keywords:

AND BETWEEN EQ GE GT

IN IS LE LIKE LT

MOD NE NOT NULL OR

Reserved Words

Commands that are supported by FastExport do not use reserved words, except:

Those that are operators

Where a specific expression is allowed

Though there is no specific restriction against doing so, it is recommended that the following be avoided as variable names:

FastExport command keywords

Teradata SQL reserved words