C-LANG Statements › STORED_PROCEDURE Statement—Specify Stored Procedure or Stored Function to Run

STORED_PROCEDURE Statement—Specify Stored Procedure or Stored Function to Run

The STORED_PROCEDURE statement specifies the database stored procedure to run. If you are using an Oracle or SQL Server database, you can also use the STORED_PROCEDURE statement to specify a stored function.

Supported Job Type

This statement is required for the Database Stored Procedure job type.

Syntax

This statement has the following format:

Type

STORED_PROCEDURE stored_procedure

stored_procedure

Specifies the stored procedure to run. You can specify a stored function if you use an Oracle or SQL Server database.

Limits: Up to 100 characters; case-sensitive

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• The agent does not support stored functions (also named user-defined functions) on DB2.
• SPNAME is an alias of STORED_PROCEDURE.

Example: Run a Stored Procedure

The following example runs the stored procedure UPDATE_INV:

AGENT CYBDB1
STORED_PROCEDURE UPDATE_INV