DB2 for Linux, UNIX, Windows Stored Procedure Cursor Type OUT Parameters
- Last Updated: May 31, 2016
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The DB2 driver supports cursor type OUT parameters for DB2 for Linux, UNIX, Windows stored procedures. To retrieve data from cursor output parameters, take the following steps:
- Define a ResultSet object for each OUT parameter with the cursor data type.
- Invoke the Connection.prepareCall method with the CALL statement as its argument to create a CallableStatement object.
- Invoke the CallableStatement.registerOutParameter method to register the data types of parameters that are defined as OUT in the CREATE PROCEDURE statement. The driver data type for cursor type output parameters is com.ddtek.jdbc.extensions.ExtTypes.CURSOR.
- Call the stored procedure.
- Invoke the CallableStatement.getObject method to retrieve the ResultSet for each OUT cursor parameter. Calling CallableStatement.getString returns a name that is associated with the result set that is returned for the parameter. You can call only CallableStatement.getObject or CallableStatement.getString on a cursor parameter.
- Retrieve rows from the ResultSet object for each OUT cursor parameter.
- Close the ResultSet.