Running DB2 Stored Procedures

Clients execute DB2 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 stored procedure.

  • In sybase mode, execute:

    EXEC procname argvalues

    or

    EXECUTE procname argvalues

    where:

    • procname is the name of the stored procedure.

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

Parent topic: DB2 Stored Procedures