Installation guide

7. mxODBC Cursor Objects
Option Comment
interpret them as case-sensitive SQL search patterns.
Possible values:
SQL.TRUE - case-insensitive identifers
SQL.FALSE - case-sensitive search patterns (default)
SQL.ATTR_NOSCAN Tell the ODBC driver not to scan the SQL commands
and unescape (expand) any ODBC escape sequences it
finds. Default is to scan for them.
Possible values:
SQL.NOSCAN_OFF (default)
SQL.NOSCAN_ON
SQL.NOSCAN_DEFAULT
.setinputsizes(sizes)
This methods does nothing in mxODBC, it is just needed for DB API
compliance.
.setoutputsize(size[, column])
This methods does nothing in mxODBC, it is just needed for DB API
compliance.
.__iter__()
Returns the cursor itself. This method makes cursor objects usable as iterators
(new in Python 2.2).
.__enter__()
Returns the cursor itself. This method makes cursor objects usable as context
manager (together with the .__exit__() method) and is called when entering a
with-block (new in Python 2.5).
.__exit__(exc_type, exc_value, exc_tb)
Returns True in case exc_type is set to None (no exception set) and closes the
cursor. Returns False in case
exc_type is set to an exception and also closes
the cursor. This method is part of the context manager API and is called when
leaving a with-block (new in Python 2.5).
7.6.1 Catalog Methods
Catalog methods allow you to access meta-level and structural information about
a data source in a portable way.
113