UTY 1664 Warning: Using the spool mode, because the SELECT request is not supported for the NoSpool method. - Teradata Tools and Utilities

FastExport, MultiLoad, and TPump (UTY Prefix) Messages

Product
Teradata Tools and Utilities
Release Number
15.10
Language
English (United States)
Last Update
2018-10-12
dita:id
B035-1096-UTY
lifecycle
archive
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