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

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

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.