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