Restrictions and Limitations - 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 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.