Create a user-defined shared library

To help make UDX code more efficient and easier to maintain, or to help make your UDXs aware of specific processing algorithms that you want to use, you can use shared libraries to define that code. User-defined shared libraries are objects in the database. You compile and register them as you do a UDF or a UDA. The shared library objects are saved on the Netezza Performance Server host.

Note: You must compile and register user-defined shared libraries before you register other UDFs, UDAs, or user-defined shared libraries that depend on them. A UDX object cannot have more than 64 direct dependencies.

In addition, make sure that you declare any of the standard C++ library header files that your user-defined shared library might require. If your shared library depends on other user-defined shared libraries, be sure to note those dependencies as you must specify them when you register this user-defined shared library.

The process to define a shared library for your UDXs consists of the following steps:
  1. Create/obtain the C++ shared library. Make sure that it is debugged and ready to use.
  2. Compile the shared library.
  3. Link the shared library.
  4. Register the library as an object in the Netezza Performance Server database.