Design a UDX

The first step in designing a UDX is to identify the type of action that you need the user-defined function or aggregate to perform. For example, you might want to implement functions that perform tasks such as specialized string operations or comparisons; custom mathematical analysis; or conversions such as metric to English measurements, Celsius to Fahrenheit, or currency conversions. In addition, it is important to identify any user-defined shared libraries that your UDXs might require or that you can develop to create more efficient UDXs that share common routines.

Before the user-defined functions feature, conversion and analysis tasks typically required users to export data from the system to another host server to do the processing and then load the converted data back into the Netezza Performance Server system for storage. With user-defined functions, you can do many or all of these analytical steps directly on the Netezza Performance Server system.