17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

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.