No DML Array Requests with Triggers - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-18
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
ktb1507075385726
Product Category
Teradata Tools and Utilities

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.