FastExport Command Conventions - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
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