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.
ECDA Option for ODBC for DB2 UDB targets does not support RSPs or host-resident requests.