Clients execute SQL stored procedures in different ways, depending upon the SQL transformation mode in effect.
In passthrough mode, the command is:
{call procname(parm1, parm2, ... parmn )}
or
{call procname( ?, ?, ?, ..., ? )}
where procname is the name of the procedure.
In sybase mode, the command is:
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.
