IBM PureData System for Analytics, Version 7.1

SQL command reference

This section describes the IBM® Netezza® SQL commands that relate to the creation and management of stored procedures.

The following table lists the SQL commands.

Table 1. Stored procedure SQL commands
Command Description More information
ALTER PROCEDURE Changes a stored procedure. The ALTER PROCEDURE command.
CALL or EXEC[UTE [ PROCEDURE]] Runs a stored procedure. The CALL and EXEC[UTE [PROCEDURE]] commands
CREATE [OR REPLACE] PROCEDURE Adds or updates a stored procedure. The CREATE [OR REPLACE] PROCEDURE commands.
DROP PROCEDURE Drops or deletes a stored procedure. The DROP PROCEDURE command.
SHOW PROCEDURE Displays information about stored procedures. The SHOW PROCEDURE command.

Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28