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
ft:locale
en-US
ft:lastEdition
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.