Get Procedure Metadata

The application can get information about procedures using the following functions:

SQLGetInfo

Returns information about how CA IDMS supports procedures:

SQL_ACCESSIBLE_PROCEDURES - The result is "Y" for for CA IDMS r15.0 or later.
SQL_BATCH_SUPPORT – The result includes the BS_SELECT_PROC bit when connected to an r17, or later IDMS CV, to indicate that procedures can include statements that return result sets. Note that the result also includes the BS_ROW_COUNT_PROC bit when connected to an r15, or later IDMS CV, to indicate that procedures can include statements that return row counts.
SQL_BATCH_ROW_COUNT – The result must be 0 to indicate that row counts are not returned to the calling application for procedure invocations.

SQLProcedures

Gets a list of the procedures defined in the SQL catalog.

The PROCEDURE_TYPE column in the result set is always SQL_PT_PROCEDURE, which indicates that the procedure does not return a value.

The result set includes 3 additional columns, which are partially defined by ODBC, but "reserved for future use":

The NUM_RESULT_SETS column indicates the maximum number of result sets that can be returned from a procedure.

SQLProcedureColumns: Gets the parameter descriptions for one or more procedures from the SQL catalog. The COLUMN_TYPE for all parameters is SQL_PARAM_INPUT_OUTPUT.