Get Details about a UDCF | Teradata VantageCloud Lake - Get Details about a UDCF - Teradata VantageCloud Lake

Lake - Using Queries, UDFs, and External Stored Procedures

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-08-12
dita:mapPath
vgj1683671089901.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
vgj1683671089901
Specify the udf_id when you need to get details about a UDCF. Retrieve the udf_id using the udcf list command. See List Installed UDCFs.
  1. Get details about a UDCF.
    tdextroutine udcf fetch <udf_id>
    ======================  ==============================================
    PROPERTY                VALUE
    ======================  ==============================================
    UDF ID                  AACHEgAA
    Database                demo_db
    Function Name           DEMO
    Specific Name           demo
    Function Class          SCALAR
    Source Language         CPP
    Parameter Style         SQL
    Is Deterministic        True
    Called On Null          False
    Routine Kind            REGULAR_FUNCTION
    External Security
    Prepare Count           False
    Protection Mode         UNPROTECTED
    Interim Size            0
    Parameter UDT IDs
    Auth ID Used
    GLOP Set Database Name
    Create/Replace Job IDs  1730238255952_d8a217949fd74
    ======================  ==============================================