Rules for Using MERGE Requests With Embedded SQL Applications - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

You can embed MERGE requests in an embedded SQL application program, then submit them interactively or prepare and then execute them dynamically.

You can specify host variables for the WHERE clause of the USING subquery clause (but not in its select list), match_condition, update_expression, and insert_expression.

All host variables must be preceded by a COLON character.