Running SQL Stored Procedures

Clients execute SQL stored procedures in different ways, depending upon the SQL transformation mode in effect.

  • In passthrough mode, execute:

    {call procname(parm1, parm2, ... parmn )}

    or:

    {call procname( ?, ?, ?, ..., ? )}

    where procname is the name of the procedure.

  • In sybase mode, execute:

    EXEC procname argvalues

    or:

    EXECUTE procname argvalues

    where:

    • procname is the name of the procedure.

    • argvalues is a list of argument values separated by commas.

    The values must be specified in the exact order specified in the create procedure statement contained in the SQL stored procedure. Input parameters are positional.

Parent topic: SQL Stored Procedures