Restrictions and Limitations - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
qja1608578437326.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the FastExport restrictions and limitations on operational features and functions.

FastExport Programming Restrictions and Limitations 
Operational Feature/Function Restriction/Limitation
Concurrent Load Utility Tasks The maximum number of concurrent FastExport tasks that can run is variable; the limit can be controlled by the system administrator. MaxLoadTasks may be overridden if TASM is active.

For the most up-to-date information on concurrent task limits see Teradata Vantage™ - Database Utilities, B035-1102. Additional information is also available in the Teradata Dynamic Workload Manager User Guide, B035-2513.

If a FastExport job exceeds the recommended limits, the database returns a 2633 error message indicating that too many loads are running, and the utility retries until:
  • It can execute the task
  • It reaches the TENACITY hours time limit specified by the BEGIN EXPORT command
Exponential operators Not allowed
Concatenation of data files Not allowed
Expressions Are evaluated from left to right, using the database order of preference, but can be overridden by parentheses
Hexadecimal Form FastExport does not accept and will not display object names specified in internal database hexadecimal form.
NUMBER DataType Usage NUMBER datatype is not supported in the nullif and apply-where clause.

SET and ACCEPT commands cannot assign and accept NUMBER datatype.