INSERT and Scalar UDFs - 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

INSERT and Scalar UDFs

You can specify a scalar UDF as a column value in the VALUES clause of an INSERT request. The rules for the invocation of a scalar UDF in a VALUES clause are as follows.

  • A scalar UDF that passes a value in the VALUES list of an INSERT request must return a value expression.
  • The arguments passed to a scalar UDF must be constants, USING values, or parameters that resolve to a constant.