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

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.