JDBC Programmer Reference › Procedures › Result Sets

Result Sets

CA IDMS r17, or later, supports procedures that return result sets.

When connected to a CA IDMS r17 system, or later, the JDBC driver supports multiple open result sets, and the DatabaseMetaData supportsMultipleResultSets and supportMultipleOpenResults methods both return true.

The result set returned by the DatabaseMetaData.getProcedures method contains 3 additional columns. JDBC indicates that these are "reserved for future use", consistent with the equivalent result set defined by ODBC.

The NUM_RESULT_SETS column indicates the maximum number of result sets that can be returned from a procedure. The value is NULL for CA IDMS r16 or earlier.

The Statement.getMoreResultSet(int) method supports all three values of the argument:

• KEEP_CURRENT_RESULT
• CLOSE_CURRENT_RESULT
• CLOSE ALL RESULTS