17.10 - getUDFOutputBlob() - 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)

Retrieves the Blob object representing the return value of a Java UDF that returns a Blob. This method can only be called from a scalar or aggregate Java UDF. If called from an aggregate Java UDF, it may only be called in the Phase.AGR_FINAL execution phase.

A java.sql.Blob object representing the return Blob value of the Java UDF.

Exceptions

IF the caller is … THEN getUDFOutputBlob() throws an SQLException to …
not a scalar or aggregate Java UDF indicate that the caller is not a scalar or aggregate Java UDF, setting the SQLException fields as follows:
  • SQLState Field = “TS000”
  • vendorCode Field = 7863
a UDF that does not return a Blob or Clob type indicate that the caller does not return a Blob or Clob, setting the SQLException fields as follows:
  • SQLState Field = “TS000”
  • vendorCode Field = 7862
a UDF that returns a Clob type indicate that the caller actually returns a Clob, setting the SQLException fields as follows:
  • SQLState Field = “TS000”
  • vendorCode Field = 7866
an aggregate Java UDF that returns a Blob, but the method is not called in the Phase.AGR_FINAL aggregation phase indicate that the method was called from an incorrect aggregation phase, setting the SQLException fields as follows:
  • SQLState Field = “TS000”
  • vendorCode Field = 7864