External UDF .so Linkage Information and Dropping Functions | Teradata Vantage - 17.10 - External UDF .so Linkage Information - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

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

This topic does not apply to SQL UDFs.

There is only one UDF .so file per application category per database per node. The system does not generate .so files for Java UDFs because the source code is contained in the associated JAR files.

Application Category Value Format of the .so File
> 0 libudf_dbid_librevno_AppCat.so
= 0 libudf_dbid_librevno.so

Whenever you create, replace, or drop a UDF, the UDF .so file for that database has to be relinked with all the other UDF object files and then redistributed to all the nodes.

The following example shows the output of a UDF creation on a Linux system. The .so file, libudf_03ee_n.so, increments each time a UDF is created, replaced, or dropped. This DROP FUNCTION operation was the ninth such UDF-related operation in the current database, so the .so file is named libudf_03ee_9.so.

The Unknown statement and 5607 Warning messages are normal.

DROP FUNCTION another;

 *** Unknown statement, type=124 complete.
 *** Warning: 5607 Check output for possible warnings encountered
     in compiling XSP/UDF.
 *** Total elapsed time was 1 second.

Check output for possible compilation warnings.
-------------------------------------------------------------
 /usr/bin/cc -G -g -Xc -I /tpasw/etc -o libudf_03ee_9.so
pre_Find_Text.o pattern.o pre_really_long_function_name.o
long_name.o pre_udf_scalar_substr.o substr.o
pre_char2hexint.o char2hexint.o   -ludf -lmw -lm