EXECUTE

Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : EXECUTE

EXECUTE

The EXECUTE statement has two uses:

•To invoke a user-defined procedure or a system stored procedure. You may use EXECUTE in place of the CALL statement

•To execute a character string, or an expression that returns a character string, within a stored procedure.

Syntax

To invoke a stored procedure:

EXEC[UTE] stored-procedure [ ( [ procedure-parameter [ , procedure-parameter ]... ] ) ]

stored-procedure ::= the name of a stored procedure

procedure-parameter ::= the input parameter(s) required by the stored procedure

Within a user-defined stored procedure:

EXEC[UTE] ( string [ + string ]... )

string ::= a string, string variable, or an expression that returns a character string

Remarks

The stored procedure syntax EXEC[UTE] (string...) does not support NCHAR values for literals and variables. Values used in constructing the string are converted to CHAR values before execution.

Examples

The following example executes a procedure without parameters:

EXEC NoParms() or CALL NoParms

The following examples execute a procedure with parameters:

EXEC Parms(vParm1, vParm2)

EXECUTE CheckMax(N.Class_ID)

============

The following procedure selects the student ID from the Billing table.

CREATE PROCEDURE tmpProc(IN :vTable CHAR(25)) RETURNS (sID INTEGER) AS

BEGIN

EXEC ('SELECT Student_ID FROM ' + :vtable);

END;

EXECUTE tmpProc('Billing')