Usage Notes - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Use the persistent object reference that FNC_LobLoc2Ref creates to copy LOB values into the intermediate storage required for aggregate UDFs.

The arguments are validated to the extent possible. If an argument is not valid, the request that invoked the UDF fails and typically returns an error that looks like this:

7554 Invalid CONTEXT_ID LOCATOR argument to LOB access function in
UDF  database_name.udf_name.

Control does not return to the UDF.