16.20 - External UDF .so Linkage Information - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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