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

prodname
Teradata Tools and Utilities
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

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