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)