UTY 1664 Warning: Using the spool mode, because the SELECT request is not supported for the NoSpool method. - FastExport - MultiLoad - Parallel Data Pump

FastExport, MultiLoad, and TPump (UTY Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
MultiLoad
Parallel Data Pump
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2021
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata® Tools and Utilities

UTY 1664 Warning: Using the spool mode, because the SELECT request is not supported for the NoSpool method.

Explanation:

Informational message.

Generated By:

EXPCLI

Remedy:

If NoSpool mode is wanted, the SELECT request can not have: - USING modifier - Access to non-data tables, such as SELECT DATE or SELECT USER - Answer set that returns a single row, such as a SELECT request with a constraint containing an equality condition on the primary index or unique secondary index column of a table - ORDER BY clause - Multi-statement requests - Joins