UTY2809 Serialization is requested but there are no KEY fields in layout. - 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

UTY2809 Serialization is requested but there are no KEY fields in layout.

Explanation:

User error

Generated By:

TLDIPTSK

Remedy 1:

Add KEY keyword to the end of the FIELD command to specify that the field is part of the hash key for purpose of serialization.

Remedy 2:

Turn SERIALIZE off when .TABLE command is used and the target table is a NoPI table.