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. - 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

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.