16.20 - 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
16.20
Content Type
Programming Reference
Publication ID
B035-1096-162K
Language
English (United States)

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