Download mxODBC - Python ODBC Database Interface

Contents
10.3
Exception Value Format................................................... 122
10.4
Error Handlers................................................................. 123
10.4.1
Examples ........................................................................................... 123
10.5
Warning Classes.............................................................. 124
10.6
Database Warnings ......................................................... 125
10.6.1
Default Error Handler ........................................................................ 125
ERROR_WARNINGFORMAT (default)...................................... 125
WARN_WARNINGFORMAT .................................................... 125
IGNORE_WARNINGFORMAT ................................................. 125
10.6.2
Custom Warning Error Handler ......................................................... 126
11.
mxODBC Functions ..........................................127
11.1
Subpackage Functions ..................................................... 127
11.2
mx.ODBC Functions ....................................................... 128
12.
mxODBC Globals and Constants .....................129
12.1
Subpackage Globals and Constants ................................. 129
sqlstate.................................................................................... 122
sqlcode ................................................................................... 122
messagetext ............................................................................ 122
lineno...................................................................................... 122
DatabaseWarning.................................................................... 124
DataSources() ......................................................................... 127
getenvattr(option) ................................................................... 127
setenvattr(option, value).......................................................... 127
statistics()................................................................................ 128
format_resultset(cursor, headers=None, colsep=' | ',
headersep='-', stringify=repr) ................................................. 128
print_resultset(cursor, headers=None) ................................... 128
SQL ......................................................................................... 129
errorclass ................................................................................ 129
sqltype .................................................................................... 129
CHAR, VARCHAR, LONGVARCHAR, BINARY, VARBINARY,
LONGVARBINARY, TINYINT, SMALLINT, INTEGER, BIGINT,