SQL commands for stored procedures

To support stored procedures in the database, the Netezza Performance Server SQL language includes commands for stored procedures:
  • ALTER PROCEDURE
  • CALL or EXEC[UTE[ PROCEDURE]]
  • CREATE [OR REPLACE] PROCEDURE
  • DROP PROCEDURE
  • SHOW PROCEDURE

You can use any SQL tool that supports ODBC, JDBC, OLE-DB to enter these commands. This publication contains examples that use the nzsql command-line tool.

In addition to these procedure-specific commands, you can also use the commands GRANT and REVOKE to allow or deny access to procedures, and COMMENT ON to add descriptions and details to the procedure definitions.