16.20 - Example: Invoking an SQL UDF Within a View Definition - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

This example invokes the SQL UDF value_expression in the select list of the definition of the view named v1.

     CREATE VIEW v1 (a, b, c) 
       AS SELECT a1, test.value_expression(3,4), c1
          FROM t1 
          WHERE a1 > b1;

The next example invokes the SQL UDF value_expression in the WHERE clause of the view named v2.

     CREATE VIEW v2 (a, b, c) 
       AS SELECT a1, b1, c1 
          FROM t1
          WHERE test.value_expression(b1, c1) > 10;