Stored procedures and UDXs

Stored procedures, which are applications that you can define as objects on the Netezza Performance Server host. Stored procedures combine the benefits of SQL to query and manipulate database information with the benefits of a procedural programming language (called NZPLSQL) to handle data processing, transaction logic, and application branching behaviors. For more information about stored procedures and the NZPLSQL language, see the IBM® Netezza® Stored Procedures Developer's Guide.

Stored procedures can be designed to call UDXs in the same way that they can call built-in functions. You can also use UDXs to do such tasks as extend the NZPLSQL language. These UDFs must be invoked by using SQL that is designed to run only on the Netezza Performance Server host inside of Postgres.