UTY1655 DML <string> must contain a single SQL statement or a pair of UPDATE and INSERT statements (for an UPSERT) when using the Array Support feature. - 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

UTY1655 DML <string> must contain a single SQL statement or a pair of UPDATE and INSERT statements (for an UPSERT) when using the Array Support feature.

Explanation:

When using the Array Support feature, DML must contain a single SQL statement or a pair of UPDATE and INSERT statements (for an UPSERT). If the DML statement is an UPSERT-type statement, it can be specified as a pair of INSERT/UPDATE statements with DO INSERT FOR MISSING UPDATE clause (TPump will create its equivalent form of UPDATE ELSE INSERT [A.K.A. Atomic Upsert] and use it as the actual DML statement), or, an UPDATE ELSE INSERT statement can be directly specified with DO INSERT FOR MISSING UPDATE clause.
Generated By: TLDSTMTS Remedy: Correct the error and re-submit the program.