Example: Invoking an SQL UDF From a MERGE Request - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

This example shows how to invoke an SQL UDF named value_expression at several points within a MERGE request.

     MERGE INTO t1
     USING (SELECT a2, b2, c2
            FROM t2
            WHERE test.value_expression(b2, c2))
                  source_tbl(a2, b2, c2)
     ON a1 = source_tbl.a2 AND
        b1 = test.value_expression(source_tbl.b2, source_tbl.c2)
     WHEN MATCHED THEN
     UPDATE SET b1 = b2, c1 = test.value_expression(2,3)
     WHEN NOT MATCHED THEN
     INSERT (a2, test.value_expression(4,5), c2);