FastExport Command Conventions - FastExport

Teradata FastExport Reference

Product
FastExport
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
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