Create a UDX

The following process outlines the steps to create a user-defined function or aggregate:
  1. Write C++ code that implements the necessary class methods.
  2. Compile the C++ program by using nzudxcompile to create object files that can be registered with the system.
  3. Use Netezza Performance Server SQL CREATE commands to register the UDX as an object in the Netezza Performance Server system.
  4. Debug the C++ program to look for and resolve any errors in the processing. Netezza Performance Server provides a test harness to assist you with debugging.
  5. Test the UDX on a development system to confirm that it runs as designed.
  6. Deploy the UDX to one or more production Netezza Performance Server systems.
  7. Give users privilege to run the user-defined function or aggregate in queries, and possibly alter the UDX to run in unfenced mode to improve performance.

Create user-defined functions through Common UDX development topics describe the steps to create UDXs, including requirements for the code, testing, and some limitations and restrictions for UDXs.