Usage Notes - Analytics Database - Teradata Vantage

SQL External Routine Programming

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
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

After you obtain the LOB locator for the distinct type, use the LOB access functions, such as FNC_LobOpen, to append data.

Predefined LOBs and distinct UDTs that represent LOBs behave the same way within UDFs, UDMs, and external stored procedures:

  • A LOB result value is empty with a length of zero unless you append data or explicitly set it to null by using the result indicator argument.
  • Setting the result indicator argument to -1 discards any data that was appended to the LOB result.
  • A distinct UDT that represents a LOB and is defined to be an INOUT parameter to an external stored procedure retains the input version if no data is appended to the LOB.