Rules for Using a Scalar UDF in an UPDATE Request
A scalar UDF can be invoked from both the SET clause and the WHERE clause of an UPDATE request. See “Example 13: UPDATE Using an SQL UDF Invocation in the SET and WHERE Clauses” on page 489.
|
FOR this clause … |
THE usage rules are the same as those for invoking a scalar UDF from the … |
|
SET |
select list of a SELECT request. See “Invoking a Scalar UDF From a SELECT Statement” on page 19. |
|
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, Teradata Database aborts the request and returns an error. |