DRDA stored procedure considerations

The i5/OS Distributed Relational Database Architecture™ (DRDA) server supports the return of one or more result sets in a stored procedure.

You can generate result sets in a stored procedure by opening one or more SQL cursors associated with SELECT statements. In addition, a maximum of one array result set can also be returned. Before V5R3, only one instance of a query opened in a stored procedure was allowed to be open at one time. Now you can make multiple calls to the same stored procedure without closing the result set cursors so that more than one instance of a query can be opened simultaneously.

Parent topic: Distributed relational database function and SQL
Related concepts:
Stored procedures
Distributed database programming
Related reference:
SET RESULT SETS
CREATE PROCEDURE (SQL)
CREATE PROCEDURE (External)