DB2 Stored Procedures

DB2 stored procedures (external stored procedures) are customer-written programs that reside on the mainframe.

The programs can be written in assembler, COBOL, PL/1 or C, and execute within the DB2 stored procedure ADDRESS space.

Note: ECDA Option for ODBC for DB2 UDB targets does not support RSPs or host-resident requests.

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

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com