No DML Array Requests with Triggers - ODBC Driver for Teradata - 16.20

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

The DML array feature does not support tables with triggers. As a work around, the request can be turned into a multi-statement request by appending a no-operation SQL statement. This causes ODBC Driver for Teradata to emulate the array request as a series of SQL requests that work on tables with triggers, but without the performance benefit of the DML array request.