Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
NULL
ORDINAL_POSITION SMALLINT not NULL Column sequence number in the primary key,
starting with 1.
PK_NAME VARCHAR(128) Primary key identifier. NULL if not applicable to
the data source.
.procedures(qualifier=None, owner=None, procedure=None)
Query the data source for information on procedures stored in a data source.
procedure can be used to limit the results to a set of procedures or a single
procedure.
The method is useful for determining the availability of stored procedures and
also for database schema introspection purposes. It can be used to check
whether a stored requires output parameters or fetching result sets.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
PROCEDURE_CAT VARCHAR(128) Always NULL.
PROCEDURE_SCHEMA VARCHAR(128) The name of the schema containing
PROCEDURE_NAME.
PROCEDURE_NAME VARCHAR(128) not
NULL
The name of the procedure.
NUM_INPUT_PARAMS INTEGER not NULL Number of input parameters.
NUM_OUTPUT_PARAMS INTEGER not NULL Number of output parameters.
NUM_RESULT_SETSNUM
_RESULT_SETS
INTEGER not NULL Number of result sets returned by the
procedure.
REMARKS VARCHAR(254) Contains the descriptive information about
the procedure.
PROCEDURE_TYPE SMALLINT Defines the procedure type:
SQL.PT_UNKNOWN: It cannot be
determined whether the procedure
returns a value.
124