CLI functions and restrictions for result sets

Result sets are a useful way to retrieve data from a stored procedure. If a client application runs a stored procedure that generates a result set, it can then use the regular CLI functions or JDBC methods such as SQLFetch() and SQLGetData() to retrieve the data. DB2 Everyplace does not support multiple result sets.

Related concepts

• The remote query and stored procedure adapter

Related tasks

• Creating the Agent Adapter subscription for the sample application
• Creating an application using the remote query and stored procedure adapter

Related reference

• Sample application code
• Creating a stored procedure using the sample application
• Creating a DB2 Everyplace application
• Supported data types for stored procedures