Get Details about a C/C++ or Java UDF | VantageCloud Lake - Get Details about a C/C++ or Java UDF - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This example assumes that you are using the config YAML file and environment variables described in Example: Creating a C UDF to define the user credentials.

Use the tdextroutine udf fetch subcommand to get more details about a C/C++ or Java UDF.

tdextroutine udf fetch UDF_ID
UDF_ID identifies the UDF. The ID is returned by the udf create subcommand or the udf list subcommand.
For example, the UDF_ID returned in the previous udf list example is AAA0DgAA, so you can get more details about that UDF using the following command:
tdextroutine udf fetch AAA0DgAA
Example output:
======================  ==============================================
PROPERTY                VALUE
======================  ==============================================
UDF ID                  AAA0DgAA
Database                MarketingDB
Function Name           udfSubStr
Specific Name           udfSubStr1
Function Class          SCALAR
Source Language         C
Parameter Style         TD_GENERAL
Is Deterministic        True
Called On Null          False
Routine Kind            REGULAR_FUNCTION
======================  ==============================================
If UDF_ID includes a slash (/) character, you must specify %2F to encode it. Slash is a reserved character.

For details about all the options of the udf fetch subcommand, see tdextroutine UDF Subcommands and Options.