FastExport Command Conventions - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
16.20
Published
September 2020
Language
English (United States)
Last Update
2020-09-11
dita:mapPath
lki1527114222329.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

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