Rules for Using a Scalar UDF in an UPDATE Request - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™

A scalar UDF can be invoked from both the SET clause and the WHERE clause of an UPDATE request. See Example: UPDATE Using an SQL UDF Invocation in the SET and WHERE Clauses.

Clause Usage rules are the same as those for invoking a scalar UDF from the …
SET Select list of a SELECT request.

You must use the alias to reference the result of a scalar UDF invocation that has an alias.

WHERE WHERE clause of a SELECT request.

The scalar UDF must be invoked from within an expression that is specified as the search condition. Otherwise, the system returns an error.

See WHERE Clause.