Description of DB2 stored procedures  Rules for datatypes as argument values

Appendix C: Using Stored Procedures

Running DB2 stored procedures

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

In passthrough mode, the command is as follows:

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

or

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

where procname is the name of the stored procedure.

In sybase mode, the command is as follows:

EXEC procname argvalues
EXECUTE procname argvalues

where:





Copyright © 2005. Sybase Inc. All rights reserved. Rules for datatypes as argument values

View this book as PDF