python ibm_db模块的使用

一、安装ibm_db

 

ibm_db在线安装，直接运行pip install ibm-db 即可，但是离线安装就相对比较麻烦，除了下载ibm_db包之外还要下载链接db2数据库的驱动包，下面是详细步骤

1.首先下载ibm_db压缩包，进入官网https://pypi.org/project/ibm-db/进行下载（官网还可以下载github开源项目），官网提供的是3.0.1的版本

下载之后解压，得到一个名为ibm_db-3.0.1的文件夹，文件夹内容如下：

 

 

 

2.下载链接db2的odbc驱动，以下是下载地址：

https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/ntx64_odbc_cli.zip，该下载过程会比较慢，耐心等待！

解压后会得到一个clidriver的文件夹，把该文件夹复制到ibm_db-3.0.1下面。

3.使用WIN+R运行CMD打开命令行界面，进入到命令行界面，进入ibm_db-3.0.1路径下，执行python setup.py install进行安装，具体操作及输出见下方：

C:\Users\MI>d:

D:\>cd D:\study\python\sample\ibm_db-3.0.1

D:\study\python\sample\ibm_db-3.0.1>python setup.py install
Detected 64-bit Python
running install
running bdist_egg
running egg_info
writing ibm_db.egg-info\PKG-INFO
writing dependency_links to ibm_db.egg-info\dependency_links.txt
writing top-level names to ibm_db.egg-info\top_level.txt
reading manifest file 'ibm_db.egg-info\SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no previously-included files found matching 'config.py'
writing manifest file 'ibm_db.egg-info\SOURCES.txt'
installing library code to build\bdist.win-amd64\egg
running install_lib
running build_py
creating build
creating build\lib
copying ibm_db_dbi.py -> build\lib
copying testfunctions.py -> build\lib
copying tests.py -> build\lib
copying ibm_db.py -> build\lib
creating build\lib\certs
copying certs\__init__.py -> build\lib\certs
creating build\lib\ibm_db_dlls
copying ibm_db_dlls\__init__.py -> build\lib\ibm_db_dlls
creating build\lib\tests
copying tests\test_000_PrepareDb.py -> build\lib\tests
copying tests\test_001_ConnDb.py -> build\lib\tests
copying tests\test_002_ConnDbUncatalogedConn.py -> build\lib\tests
copying tests\test_003_NumAffectedRows.py -> build\lib\tests
copying tests\test_004_ConnWrongUserPwd.py -> build\lib\tests
copying tests\test_005_ConnBadUserBadPwd.py -> build\lib\tests
copying tests\test_006_ConnPassingOpts.py -> build\lib\tests
copying tests\test_007_pConnPassingOpts.py -> build\lib\tests
copying tests\test_008_ColumnInfo.py -> build\lib\tests
copying tests\test_010_UpdateRowCount.py -> build\lib\tests
copying tests\test_011_DeleteRowCount.py -> build\lib\tests
copying tests\test_012_KeysetDrivenCursorSelect01.py -> build\lib\tests
copying tests\test_013_KeysetDrivenCursorSelect02.py -> build\lib\tests
copying tests\test_014_KeysetDrivenCursorNegativeRow.py -> build\lib\tests
copying tests\test_015_InsertDeleteRowCount_01.py -> build\lib\tests
copying tests\test_016_InsertDeleteRowCount_02.py -> build\lib\tests
copying tests\test_017_selectRowcountPrefetchSTMTOpt.py -> build\lib\tests
copying tests\test_018_selectRowcountPrefetchSetOpt.py -> build\lib\tests
copying tests\test_019_selectRowcountPrefetchPrepOpt.py -> build\lib\tests
copying tests\test_020_RollbackDelete.py -> build\lib\tests
copying tests\test_021_CommitDelete.py -> build\lib\tests
copying tests\test_022_RollbackInsert.py -> build\lib\tests
copying tests\test_023_ColumnPrivileges.py -> build\lib\tests
copying tests\test_024_ForeignKeys.py -> build\lib\tests
copying tests\test_025_PrimaryKeys.py -> build\lib\tests
copying tests\test_030_Result.py -> build\lib\tests
copying tests\test_031_ResultIndexPosition.py -> build\lib\tests
copying tests\test_032_ResultIndexName.py -> build\lib\tests
copying tests\test_033_ResultOutSequenceColumn.py -> build\lib\tests
copying tests\test_034_FetchAssoc.py -> build\lib\tests
copying tests\test_035_FetchRow_01.py -> build\lib\tests
copying tests\test_036_FetchRow_02.py -> build\lib\tests
copying tests\test_037_FetchRowIndexPos.py -> build\lib\tests
copying tests\test_038_FetchRowIndexPosNested_01.py -> build\lib\tests
copying tests\test_039_FetchRowIndexPosNested_02.py -> build\lib\tests
copying tests\test_03a_ResultNonExistCol.py -> build\lib\tests
copying tests\test_040_FetchTuple.py -> build\lib\tests
copying tests\test_041_FetchTupleMany_01.py -> build\lib\tests
copying tests\test_042_FetchTupleMany_02.py -> build\lib\tests
copying tests\test_043_FetchTupleMany_03.py -> build\lib\tests
copying tests\test_044_FetchTupleMany_04.py -> build\lib\tests
copying tests\test_045_FetchTupleBinaryData_01.py -> build\lib\tests
copying tests\test_046_FetchTupleMany_05.py -> build\lib\tests
copying tests\test_047_FetchTupleMany_06.py -> build\lib\tests
copying tests\test_048_FetchTupleBinaryData_02.py -> build\lib\tests
copying tests\test_049_InsertNoneParam.py -> build\lib\tests
copying tests\test_050_AutocommitStatus.py -> build\lib\tests
copying tests\test_051_SetAutocommit_01.py -> build\lib\tests
copying tests\test_052_SetAutocommit_02.py -> build\lib\tests
copying tests\test_053_AttrThruConn.py -> build\lib\tests
copying tests\test_054_CursorType.py -> build\lib\tests
copying tests\test_060_Tables_01.py -> build\lib\tests
copying tests\test_061_Tables_02.py -> build\lib\tests
copying tests\test_062_Tables_03.py -> build\lib\tests
copying tests\test_063_Tables_04.py -> build\lib\tests
copying tests\test_064_Tables_05.py -> build\lib\tests
copying tests\test_065_FilterTableName.py -> build\lib\tests
copying tests\test_066_TableObjects.py -> build\lib\tests
copying tests\test_070_Close.py -> build\lib\tests
copying tests\test_071_CloseSuccess.py -> build\lib\tests
copying tests\test_080_ConnWrongDbAlias.py -> build\lib\tests
copying tests\test_081_ConnWrongUser.py -> build\lib\tests
copying tests\test_082_ConnWrongPwd.py -> build\lib\tests
copying tests\test_090_ConnmsgWrongDbAlias.py -> build\lib\tests
copying tests\test_091_ConnmsgWrongUser.py -> build\lib\tests
copying tests\test_092_ConnmsgWrongPwd.py -> build\lib\tests
copying tests\test_100_SelectDeleteInsertFieldCount.py -> build\lib\tests
copying tests\test_101_InsertDeleteFieldCount.py -> build\lib\tests
copying tests\test_102_NumFieldsSelect_01.py -> build\lib\tests
copying tests\test_103_NumFieldsSelect_02.py -> build\lib\tests
copying tests\test_110_FieldNum.py -> build\lib\tests
copying tests\test_111_FieldNumAddCol.py -> build\lib\tests
copying tests\test_112_FieldNumDiffCaseColNames.py -> build\lib\tests
copying tests\test_113_DateTest.py -> build\lib\tests
copying tests\test_114_NumericTest_01.py -> build\lib\tests
copying tests\test_115_NumericTest_02.py -> build\lib\tests
copying tests\test_116_ConnActive.py -> build\lib\tests
copying tests\test_120_FieldName.py -> build\lib\tests
copying tests\test_121_FieldNameAddCol.py -> build\lib\tests
copying tests\test_122_FieldNameDiffCaseColNames.py -> build\lib\tests
copying tests\test_123_FieldNamePos_01.py -> build\lib\tests
copying tests\test_124_FieldNamePos_02.py -> build\lib\tests
copying tests\test_125_FieldNamePos_03.py -> build\lib\tests
copying tests\test_130_PrepExecuteSelectStmt.py -> build\lib\tests
copying tests\test_131_PrepareExecuteSelectStatementParams.py -> build\lib\tests
copying tests\test_132_ExecuteStatementArrayMultipleParams.py -> build\lib\tests
copying tests\test_133_ExecuteLongInputParams.py -> build\lib\tests
copying tests\test_140_BindParamSelectStmt.py -> build\lib\tests
copying tests\test_141_BindParamSelectStmtMultipleParams_01.py -> build\lib\tests
copying tests\test_142_BindParamSelectStmtMultipleParams_02.py -> build\lib\tests
copying tests\test_143_BindParamInsertStmtNoneParam.py -> build\lib\tests
copying tests\test_144_BindParamInsertStmtPARAM_FILE.py -> build\lib\tests
copying tests\test_145_BindRetrieveNoneEmptyString.py -> build\lib\tests
copying tests\test_146_CallSPINAndOUTParams.py -> build\lib\tests
copying tests\test_147_PrepareWithWrongType.py -> build\lib\tests
copying tests\test_148_CallSPDiffBindPattern_01.py -> build\lib\tests
copying tests\test_150_FetchAssocSelect_01.py -> build\lib\tests
copying tests\test_151_FetchAssocSelect_02.py -> build\lib\tests
copying tests\test_152_FetchAssocSelect_03.py -> build\lib\tests
copying tests\test_153_FetchAssocSelect_04.py -> build\lib\tests
copying tests\test_154_AllFetches.py -> build\lib\tests
copying tests\test_155_FetchAssocSelect_05.py -> build\lib\tests
copying tests\test_156_FetchAssocNestedSelects_01.py -> build\lib\tests
copying tests\test_157a_FetchAssocWithoutScrollableCursorErr.py -> build\lib\tests
copying tests\test_157b_FetchAssocScrollableCursor_02.py -> build\lib\tests
copying tests\test_157_FetchAssocScrollableCursor_01.py -> build\lib\tests
copying tests\test_158_FetchAssocNestedSelects_02.py -> build\lib\tests
copying tests\test_159a_FetchAssocSeveralRows_02.py -> build\lib\tests
copying tests\test_159_FetchAssocSeveralRows_01.py -> build\lib\tests
copying tests\test_160_FetchBoth.py -> build\lib\tests
copying tests\test_161_FetchBothNestedSelects_01.py -> build\lib\tests
copying tests\test_162_FetchBothNestedSelects_02.py -> build\lib\tests
copying tests\test_180_StmtErrMsg.py -> build\lib\tests
copying tests\test_190_ColumnsTable_01.py -> build\lib\tests
copying tests\test_191_ColumnsTable_02.py -> build\lib\tests
copying tests\test_195_InsertRetrieveXMLData_01.py -> build\lib\tests
copying tests\test_196_InsertRetrieveXMLData_02.py -> build\lib\tests
copying tests\test_197_StatisticsIndexes.py -> build\lib\tests
copying tests\test_200_MultipleRsltsetsUniformColDefs.py -> build\lib\tests
copying tests\test_201_MultipleRsltsetsDiffColDefs.py -> build\lib\tests
copying tests\test_210_FieldDisplaySize_01.py -> build\lib\tests
copying tests\test_211_FieldDisplaySize_02.py -> build\lib\tests
copying tests\test_212_FieldDisplaySize_03.py -> build\lib\tests
copying tests\test_213_FieldDisplaySize_04.py -> build\lib\tests
copying tests\test_220_PersistentConn.py -> build\lib\tests
copying tests\test_221_100PersistentConns.py -> build\lib\tests
copying tests\test_230_FieldTypePos.py -> build\lib\tests
copying tests\test_231_FieldTypeName.py -> build\lib\tests
copying tests\test_232_FieldTypePosName.py -> build\lib\tests
copying tests\test_240_FieldWidthPosName_01.py -> build\lib\tests
copying tests\test_241_FieldWidthPosName_02.py -> build\lib\tests
copying tests\test_250_FreeResult_01.py -> build\lib\tests
copying tests\test_251_FreeResult_02.py -> build\lib\tests
copying tests\test_260_FetchTupleMany_07.py -> build\lib\tests
copying tests\test_261_FetchObjectAccess.py -> build\lib\tests
copying tests\test_264_InsertRetrieveBIGINTTypeColumn.py -> build\lib\tests
copying tests\test_265_NoAffectedRows.py -> build\lib\tests
copying tests\test_300_ServerInfo.py -> build\lib\tests
copying tests\test_310_ClientInfo.py -> build\lib\tests
copying tests\test_311_InsertSelectDeleteNumLiterals.py -> build\lib\tests
copying tests\test_52949_TestSPIntVarcharXml.py -> build\lib\tests
copying tests\test_6528_ScopingProblemBindParam.py -> build\lib\tests
copying tests\test_6561_InsertNULLValues.py -> build\lib\tests
copying tests\test_6755_ExtraNULLChar_ResultCLOBCol.py -> build\lib\tests
copying tests\test_6792_FieldTypeRetStrDatetimeTimestamp.py -> build\lib\tests
copying tests\test_createdbNX.py -> build\lib\tests
copying tests\test_createDropDB.py -> build\lib\tests
copying tests\test_cursortype.py -> build\lib\tests
copying tests\test_decfloat.py -> build\lib\tests
copying tests\test_decimal.py -> build\lib\tests
copying tests\test_execute_many.py -> build\lib\tests
copying tests\test_InsertRetrieveDateTimeTypeColumn.py -> build\lib\tests
copying tests\test_recreateDB.py -> build\lib\tests
copying tests\test_setgetOption.py -> build\lib\tests
copying tests\test_trusted_context_connect.py -> build\lib\tests
copying tests\test_trusted_context_pconnect.py -> build\lib\tests
copying tests\test_warn.py -> build\lib\tests
copying tests\__init__.py -> build\lib\tests
copying certs\ibm_certs.pem -> build\lib\certs
copying ibm_db_dlls\ibm_db.dll -> build\lib\ibm_db_dlls
copying tests\pic1.jpg -> build\lib\tests
copying tests\spook.png -> build\lib\tests
Fixing build\lib\ibm_db_dbi.py build\lib\testfunctions.py build\lib\tests.py build\lib\ibm_db.py build\lib\certs\__init__.py build\lib\ibm_db_dlls\__init__.py build\lib\tests\test_000_PrepareDb.py build\lib\tests\test_001_ConnDb.py build\lib\tests\test_002_ConnDbUncatalogedConn.py build\lib\tests\test_003_NumAffectedRows.py build\lib\tests\test_004_ConnWrongUserPwd.py build\lib\tests\test_005_ConnBadUserBadPwd.py build\lib\tests\test_006_ConnPassingOpts.py build\lib\tests\test_007_pConnPassingOpts.py build\lib\tests\test_008_ColumnInfo.py build\lib\tests\test_010_UpdateRowCount.py build\lib\tests\test_011_DeleteRowCount.py build\lib\tests\test_012_KeysetDrivenCursorSelect01.py build\lib\tests\test_013_KeysetDrivenCursorSelect02.py build\lib\tests\test_014_KeysetDrivenCursorNegativeRow.py build\lib\tests\test_015_InsertDeleteRowCount_01.py build\lib\tests\test_016_InsertDeleteRowCount_02.py build\lib\tests\test_017_selectRowcountPrefetchSTMTOpt.py build\lib\tests\test_018_selectRowcountPrefetchSetOpt.py build\lib\tests\test_019_selectRowcountPrefetchPrepOpt.py build\lib\tests\test_020_RollbackDelete.py build\lib\tests\test_021_CommitDelete.py build\lib\tests\test_022_RollbackInsert.py build\lib\tests\test_023_ColumnPrivileges.py build\lib\tests\test_024_ForeignKeys.py build\lib\tests\test_025_PrimaryKeys.py build\lib\tests\test_030_Result.py build\lib\tests\test_031_ResultIndexPosition.py build\lib\tests\test_032_ResultIndexName.py build\lib\tests\test_033_ResultOutSequenceColumn.py build\lib\tests\test_034_FetchAssoc.py build\lib\tests\test_035_FetchRow_01.py build\lib\tests\test_036_FetchRow_02.py build\lib\tests\test_037_FetchRowIndexPos.py build\lib\tests\test_038_FetchRowIndexPosNested_01.py build\lib\tests\test_039_FetchRowIndexPosNested_02.py build\lib\tests\test_03a_ResultNonExistCol.py build\lib\tests\test_040_FetchTuple.py build\lib\tests\test_041_FetchTupleMany_01.py build\lib\tests\test_042_FetchTupleMany_02.py build\lib\tests\test_043_FetchTupleMany_03.py build\lib\tests\test_044_FetchTupleMany_04.py build\lib\tests\test_045_FetchTupleBinaryData_01.py build\lib\tests\test_046_FetchTupleMany_05.py build\lib\tests\test_047_FetchTupleMany_06.py build\lib\tests\test_048_FetchTupleBinaryData_02.py build\lib\tests\test_049_InsertNoneParam.py build\lib\tests\test_050_AutocommitStatus.py build\lib\tests\test_051_SetAutocommit_01.py build\lib\tests\test_052_SetAutocommit_02.py build\lib\tests\test_053_AttrThruConn.py build\lib\tests\test_054_CursorType.py build\lib\tests\test_060_Tables_01.py build\lib\tests\test_061_Tables_02.py build\lib\tests\test_062_Tables_03.py build\lib\tests\test_063_Tables_04.py build\lib\tests\test_064_Tables_05.py build\lib\tests\test_065_FilterTableName.py build\lib\tests\test_066_TableObjects.py build\lib\tests\test_070_Close.py build\lib\tests\test_071_CloseSuccess.py build\lib\tests\test_080_ConnWrongDbAlias.py build\lib\tests\test_081_ConnWrongUser.py build\lib\tests\test_082_ConnWrongPwd.py build\lib\tests\test_090_ConnmsgWrongDbAlias.py build\lib\tests\test_091_ConnmsgWrongUser.py build\lib\tests\test_092_ConnmsgWrongPwd.py build\lib\tests\test_100_SelectDeleteInsertFieldCount.py build\lib\tests\test_101_InsertDeleteFieldCount.py build\lib\tests\test_102_NumFieldsSelect_01.py build\lib\tests\test_103_NumFieldsSelect_02.py build\lib\tests\test_110_FieldNum.py build\lib\tests\test_111_FieldNumAddCol.py build\lib\tests\test_112_FieldNumDiffCaseColNames.py build\lib\tests\test_113_DateTest.py build\lib\tests\test_114_NumericTest_01.py build\lib\tests\test_115_NumericTest_02.py build\lib\tests\test_116_ConnActive.py build\lib\tests\test_120_FieldName.py build\lib\tests\test_121_FieldNameAddCol.py build\lib\tests\test_122_FieldNameDiffCaseColNames.py build\lib\tests\test_123_FieldNamePos_01.py build\lib\tests\test_124_FieldNamePos_02.py build\lib\tests\test_125_FieldNamePos_03.py build\lib\tests\test_130_PrepExecuteSelectStmt.py build\lib\tests\test_131_PrepareExecuteSelectStatementParams.py build\lib\tests\test_132_ExecuteStatementArrayMultipleParams.py build\lib\tests\test_133_ExecuteLongInputParams.py build\lib\tests\test_140_BindParamSelectStmt.py build\lib\tests\test_141_BindParamSelectStmtMultipleParams_01.py build\lib\tests\test_142_BindParamSelectStmtMultipleParams_02.py build\lib\tests\test_143_BindParamInsertStmtNoneParam.py build\lib\tests\test_144_BindParamInsertStmtPARAM_FILE.py build\lib\tests\test_145_BindRetrieveNoneEmptyString.py build\lib\tests\test_146_CallSPINAndOUTParams.py build\lib\tests\test_147_PrepareWithWrongType.py build\lib\tests\test_148_CallSPDiffBindPattern_01.py build\lib\tests\test_150_FetchAssocSelect_01.py build\lib\tests\test_151_FetchAssocSelect_02.py build\lib\tests\test_152_FetchAssocSelect_03.py build\lib\tests\test_153_FetchAssocSelect_04.py build\lib\tests\test_154_AllFetches.py build\lib\tests\test_155_FetchAssocSelect_05.py build\lib\tests\test_156_FetchAssocNestedSelects_01.py build\lib\tests\test_157a_FetchAssocWithoutScrollableCursorErr.py build\lib\tests\test_157b_FetchAssocScrollableCursor_02.py build\lib\tests\test_157_FetchAssocScrollableCursor_01.py build\lib\tests\test_158_FetchAssocNestedSelects_02.py build\lib\tests\test_159a_FetchAssocSeveralRows_02.py build\lib\tests\test_159_FetchAssocSeveralRows_01.py build\lib\tests\test_160_FetchBoth.py build\lib\tests\test_161_FetchBothNestedSelects_01.py build\lib\tests\test_162_FetchBothNestedSelects_02.py build\lib\tests\test_180_StmtErrMsg.py build\lib\tests\test_190_ColumnsTable_01.py build\lib\tests\test_191_ColumnsTable_02.py build\lib\tests\test_195_InsertRetrieveXMLData_01.py build\lib\tests\test_196_InsertRetrieveXMLData_02.py build\lib\tests\test_197_StatisticsIndexes.py build\lib\tests\test_200_MultipleRsltsetsUniformColDefs.py build\lib\tests\test_201_MultipleRsltsetsDiffColDefs.py build\lib\tests\test_210_FieldDisplaySize_01.py build\lib\tests\test_211_FieldDisplaySize_02.py build\lib\tests\test_212_FieldDisplaySize_03.py build\lib\tests\test_213_FieldDisplaySize_04.py build\lib\tests\test_220_PersistentConn.py build\lib\tests\test_221_100PersistentConns.py build\lib\tests\test_230_FieldTypePos.py build\lib\tests\test_231_FieldTypeName.py build\lib\tests\test_232_FieldTypePosName.py build\lib\tests\test_240_FieldWidthPosName_01.py build\lib\tests\test_241_FieldWidthPosName_02.py build\lib\tests\test_250_FreeResult_01.py build\lib\tests\test_251_FreeResult_02.py build\lib\tests\test_260_FetchTupleMany_07.py build\lib\tests\test_261_FetchObjectAccess.py build\lib\tests\test_264_InsertRetrieveBIGINTTypeColumn.py build\lib\tests\test_265_NoAffectedRows.py build\lib\tests\test_300_ServerInfo.py build\lib\tests\test_310_ClientInfo.py build\lib\tests\test_311_InsertSelectDeleteNumLiterals.py build\lib\tests\test_52949_TestSPIntVarcharXml.py build\lib\tests\test_6528_ScopingProblemBindParam.py build\lib\tests\test_6561_InsertNULLValues.py build\lib\tests\test_6755_ExtraNULLChar_ResultCLOBCol.py build\lib\tests\test_6792_FieldTypeRetStrDatetimeTimestamp.py build\lib\tests\test_createdbNX.py build\lib\tests\test_createDropDB.py build\lib\tests\test_cursortype.py build\lib\tests\test_decfloat.py build\lib\tests\test_decimal.py build\lib\tests\test_execute_many.py build\lib\tests\test_InsertRetrieveDateTimeTypeColumn.py build\lib\tests\test_recreateDB.py build\lib\tests\test_setgetOption.py build\lib\tests\test_trusted_context_connect.py build\lib\tests\test_trusted_context_pconnect.py build\lib\tests\test_warn.py build\lib\tests\__init__.py
Skipping optional fixer: buffer
Skipping optional fixer: idioms
Skipping optional fixer: set_literal
Skipping optional fixer: ws_comma
Fixing build\lib\ibm_db_dbi.py build\lib\testfunctions.py build\lib\tests.py build\lib\ibm_db.py build\lib\certs\__init__.py build\lib\ibm_db_dlls\__init__.py build\lib\tests\test_000_PrepareDb.py build\lib\tests\test_001_ConnDb.py build\lib\tests\test_002_ConnDbUncatalogedConn.py build\lib\tests\test_003_NumAffectedRows.py build\lib\tests\test_004_ConnWrongUserPwd.py build\lib\tests\test_005_ConnBadUserBadPwd.py build\lib\tests\test_006_ConnPassingOpts.py build\lib\tests\test_007_pConnPassingOpts.py build\lib\tests\test_008_ColumnInfo.py build\lib\tests\test_010_UpdateRowCount.py build\lib\tests\test_011_DeleteRowCount.py build\lib\tests\test_012_KeysetDrivenCursorSelect01.py build\lib\tests\test_013_KeysetDrivenCursorSelect02.py build\lib\tests\test_014_KeysetDrivenCursorNegativeRow.py build\lib\tests\test_015_InsertDeleteRowCount_01.py build\lib\tests\test_016_InsertDeleteRowCount_02.py build\lib\tests\test_017_selectRowcountPrefetchSTMTOpt.py build\lib\tests\test_018_selectRowcountPrefetchSetOpt.py build\lib\tests\test_019_selectRowcountPrefetchPrepOpt.py build\lib\tests\test_020_RollbackDelete.py build\lib\tests\test_021_CommitDelete.py build\lib\tests\test_022_RollbackInsert.py build\lib\tests\test_023_ColumnPrivileges.py build\lib\tests\test_024_ForeignKeys.py build\lib\tests\test_025_PrimaryKeys.py build\lib\tests\test_030_Result.py build\lib\tests\test_031_ResultIndexPosition.py build\lib\tests\test_032_ResultIndexName.py build\lib\tests\test_033_ResultOutSequenceColumn.py build\lib\tests\test_034_FetchAssoc.py build\lib\tests\test_035_FetchRow_01.py build\lib\tests\test_036_FetchRow_02.py build\lib\tests\test_037_FetchRowIndexPos.py build\lib\tests\test_038_FetchRowIndexPosNested_01.py build\lib\tests\test_039_FetchRowIndexPosNested_02.py build\lib\tests\test_03a_ResultNonExistCol.py build\lib\tests\test_040_FetchTuple.py build\lib\tests\test_041_FetchTupleMany_01.py build\lib\tests\test_042_FetchTupleMany_02.py build\lib\tests\test_043_FetchTupleMany_03.py build\lib\tests\test_044_FetchTupleMany_04.py build\lib\tests\test_045_FetchTupleBinaryData_01.py build\lib\tests\test_046_FetchTupleMany_05.py build\lib\tests\test_047_FetchTupleMany_06.py build\lib\tests\test_048_FetchTupleBinaryData_02.py build\lib\tests\test_049_InsertNoneParam.py build\lib\tests\test_050_AutocommitStatus.py build\lib\tests\test_051_SetAutocommit_01.py build\lib\tests\test_052_SetAutocommit_02.py build\lib\tests\test_053_AttrThruConn.py build\lib\tests\test_054_CursorType.py build\lib\tests\test_060_Tables_01.py build\lib\tests\test_061_Tables_02.py build\lib\tests\test_062_Tables_03.py build\lib\tests\test_063_Tables_04.py build\lib\tests\test_064_Tables_05.py build\lib\tests\test_065_FilterTableName.py build\lib\tests\test_066_TableObjects.py build\lib\tests\test_070_Close.py build\lib\tests\test_071_CloseSuccess.py build\lib\tests\test_080_ConnWrongDbAlias.py build\lib\tests\test_081_ConnWrongUser.py build\lib\tests\test_082_ConnWrongPwd.py build\lib\tests\test_090_ConnmsgWrongDbAlias.py build\lib\tests\test_091_ConnmsgWrongUser.py build\lib\tests\test_092_ConnmsgWrongPwd.py build\lib\tests\test_100_SelectDeleteInsertFieldCount.py build\lib\tests\test_101_InsertDeleteFieldCount.py build\lib\tests\test_102_NumFieldsSelect_01.py build\lib\tests\test_103_NumFieldsSelect_02.py build\lib\tests\test_110_FieldNum.py build\lib\tests\test_111_FieldNumAddCol.py build\lib\tests\test_112_FieldNumDiffCaseColNames.py build\lib\tests\test_113_DateTest.py build\lib\tests\test_114_NumericTest_01.py build\lib\tests\test_115_NumericTest_02.py build\lib\tests\test_116_ConnActive.py build\lib\tests\test_120_FieldName.py build\lib\tests\test_121_FieldNameAddCol.py build\lib\tests\test_122_FieldNameDiffCaseColNames.py build\lib\tests\test_123_FieldNamePos_01.py build\lib\tests\test_124_FieldNamePos_02.py build\lib\tests\test_125_FieldNamePos_03.py build\lib\tests\test_130_PrepExecuteSelectStmt.py build\lib\tests\test_131_PrepareExecuteSelectStatementParams.py build\lib\tests\test_132_ExecuteStatementArrayMultipleParams.py build\lib\tests\test_133_ExecuteLongInputParams.py build\lib\tests\test_140_BindParamSelectStmt.py build\lib\tests\test_141_BindParamSelectStmtMultipleParams_01.py build\lib\tests\test_142_BindParamSelectStmtMultipleParams_02.py build\lib\tests\test_143_BindParamInsertStmtNoneParam.py build\lib\tests\test_144_BindParamInsertStmtPARAM_FILE.py build\lib\tests\test_145_BindRetrieveNoneEmptyString.py build\lib\tests\test_146_CallSPINAndOUTParams.py build\lib\tests\test_147_PrepareWithWrongType.py build\lib\tests\test_148_CallSPDiffBindPattern_01.py build\lib\tests\test_150_FetchAssocSelect_01.py build\lib\tests\test_151_FetchAssocSelect_02.py build\lib\tests\test_152_FetchAssocSelect_03.py build\lib\tests\test_153_FetchAssocSelect_04.py build\lib\tests\test_154_AllFetches.py build\lib\tests\test_155_FetchAssocSelect_05.py build\lib\tests\test_156_FetchAssocNestedSelects_01.py build\lib\tests\test_157a_FetchAssocWithoutScrollableCursorErr.py build\lib\tests\test_157b_FetchAssocScrollableCursor_02.py build\lib\tests\test_157_FetchAssocScrollableCursor_01.py build\lib\tests\test_158_FetchAssocNestedSelects_02.py build\lib\tests\test_159a_FetchAssocSeveralRows_02.py build\lib\tests\test_159_FetchAssocSeveralRows_01.py build\lib\tests\test_160_FetchBoth.py build\lib\tests\test_161_FetchBothNestedSelects_01.py build\lib\tests\test_162_FetchBothNestedSelects_02.py build\lib\tests\test_180_StmtErrMsg.py build\lib\tests\test_190_ColumnsTable_01.py build\lib\tests\test_191_ColumnsTable_02.py build\lib\tests\test_195_InsertRetrieveXMLData_01.py build\lib\tests\test_196_InsertRetrieveXMLData_02.py build\lib\tests\test_197_StatisticsIndexes.py build\lib\tests\test_200_MultipleRsltsetsUniformColDefs.py build\lib\tests\test_201_MultipleRsltsetsDiffColDefs.py build\lib\tests\test_210_FieldDisplaySize_01.py build\lib\tests\test_211_FieldDisplaySize_02.py build\lib\tests\test_212_FieldDisplaySize_03.py build\lib\tests\test_213_FieldDisplaySize_04.py build\lib\tests\test_220_PersistentConn.py build\lib\tests\test_221_100PersistentConns.py build\lib\tests\test_230_FieldTypePos.py build\lib\tests\test_231_FieldTypeName.py build\lib\tests\test_232_FieldTypePosName.py build\lib\tests\test_240_FieldWidthPosName_01.py build\lib\tests\test_241_FieldWidthPosName_02.py build\lib\tests\test_250_FreeResult_01.py build\lib\tests\test_251_FreeResult_02.py build\lib\tests\test_260_FetchTupleMany_07.py build\lib\tests\test_261_FetchObjectAccess.py build\lib\tests\test_264_InsertRetrieveBIGINTTypeColumn.py build\lib\tests\test_265_NoAffectedRows.py build\lib\tests\test_300_ServerInfo.py build\lib\tests\test_310_ClientInfo.py build\lib\tests\test_311_InsertSelectDeleteNumLiterals.py build\lib\tests\test_52949_TestSPIntVarcharXml.py build\lib\tests\test_6528_ScopingProblemBindParam.py build\lib\tests\test_6561_InsertNULLValues.py build\lib\tests\test_6755_ExtraNULLChar_ResultCLOBCol.py build\lib\tests\test_6792_FieldTypeRetStrDatetimeTimestamp.py build\lib\tests\test_createdbNX.py build\lib\tests\test_createDropDB.py build\lib\tests\test_cursortype.py build\lib\tests\test_decfloat.py build\lib\tests\test_decimal.py build\lib\tests\test_execute_many.py build\lib\tests\test_InsertRetrieveDateTimeTypeColumn.py build\lib\tests\test_recreateDB.py build\lib\tests\test_setgetOption.py build\lib\tests\test_trusted_context_connect.py build\lib\tests\test_trusted_context_pconnect.py build\lib\tests\test_warn.py build\lib\tests\__init__.py
Skipping optional fixer: buffer
Skipping optional fixer: idioms
Skipping optional fixer: set_literal
Skipping optional fixer: ws_comma
creating build\bdist.win-amd64
creating build\bdist.win-amd64\egg
creating build\bdist.win-amd64\egg\certs
copying build\lib\certs\ibm_certs.pem -> build\bdist.win-amd64\egg\certs
copying build\lib\certs\__init__.py -> build\bdist.win-amd64\egg\certs
copying build\lib\ibm_db.py -> build\bdist.win-amd64\egg
copying build\lib\ibm_db_dbi.py -> build\bdist.win-amd64\egg
creating build\bdist.win-amd64\egg\ibm_db_dlls
copying build\lib\ibm_db_dlls\ibm_db.dll -> build\bdist.win-amd64\egg\ibm_db_dlls
copying build\lib\ibm_db_dlls\__init__.py -> build\bdist.win-amd64\egg\ibm_db_dlls
copying build\lib\testfunctions.py -> build\bdist.win-amd64\egg
creating build\bdist.win-amd64\egg\tests
copying build\lib\tests\pic1.jpg -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\spook.png -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_000_PrepareDb.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_001_ConnDb.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_002_ConnDbUncatalogedConn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_003_NumAffectedRows.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_004_ConnWrongUserPwd.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_005_ConnBadUserBadPwd.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_006_ConnPassingOpts.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_007_pConnPassingOpts.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_008_ColumnInfo.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_010_UpdateRowCount.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_011_DeleteRowCount.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_012_KeysetDrivenCursorSelect01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_013_KeysetDrivenCursorSelect02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_014_KeysetDrivenCursorNegativeRow.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_015_InsertDeleteRowCount_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_016_InsertDeleteRowCount_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_017_selectRowcountPrefetchSTMTOpt.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_018_selectRowcountPrefetchSetOpt.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_019_selectRowcountPrefetchPrepOpt.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_020_RollbackDelete.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_021_CommitDelete.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_022_RollbackInsert.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_023_ColumnPrivileges.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_024_ForeignKeys.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_025_PrimaryKeys.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_030_Result.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_031_ResultIndexPosition.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_032_ResultIndexName.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_033_ResultOutSequenceColumn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_034_FetchAssoc.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_035_FetchRow_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_036_FetchRow_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_037_FetchRowIndexPos.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_038_FetchRowIndexPosNested_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_039_FetchRowIndexPosNested_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_03a_ResultNonExistCol.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_040_FetchTuple.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_041_FetchTupleMany_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_042_FetchTupleMany_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_043_FetchTupleMany_03.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_044_FetchTupleMany_04.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_045_FetchTupleBinaryData_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_046_FetchTupleMany_05.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_047_FetchTupleMany_06.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_048_FetchTupleBinaryData_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_049_InsertNoneParam.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_050_AutocommitStatus.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_051_SetAutocommit_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_052_SetAutocommit_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_053_AttrThruConn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_054_CursorType.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_060_Tables_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_061_Tables_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_062_Tables_03.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_063_Tables_04.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_064_Tables_05.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_065_FilterTableName.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_066_TableObjects.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_070_Close.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_071_CloseSuccess.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_080_ConnWrongDbAlias.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_081_ConnWrongUser.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_082_ConnWrongPwd.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_090_ConnmsgWrongDbAlias.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_091_ConnmsgWrongUser.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_092_ConnmsgWrongPwd.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_100_SelectDeleteInsertFieldCount.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_101_InsertDeleteFieldCount.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_102_NumFieldsSelect_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_103_NumFieldsSelect_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_110_FieldNum.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_111_FieldNumAddCol.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_112_FieldNumDiffCaseColNames.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_113_DateTest.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_114_NumericTest_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_115_NumericTest_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_116_ConnActive.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_120_FieldName.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_121_FieldNameAddCol.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_122_FieldNameDiffCaseColNames.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_123_FieldNamePos_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_124_FieldNamePos_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_125_FieldNamePos_03.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_130_PrepExecuteSelectStmt.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_131_PrepareExecuteSelectStatementParams.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_132_ExecuteStatementArrayMultipleParams.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_133_ExecuteLongInputParams.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_140_BindParamSelectStmt.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_141_BindParamSelectStmtMultipleParams_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_142_BindParamSelectStmtMultipleParams_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_143_BindParamInsertStmtNoneParam.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_144_BindParamInsertStmtPARAM_FILE.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_145_BindRetrieveNoneEmptyString.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_146_CallSPINAndOUTParams.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_147_PrepareWithWrongType.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_148_CallSPDiffBindPattern_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_150_FetchAssocSelect_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_151_FetchAssocSelect_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_152_FetchAssocSelect_03.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_153_FetchAssocSelect_04.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_154_AllFetches.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_155_FetchAssocSelect_05.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_156_FetchAssocNestedSelects_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_157a_FetchAssocWithoutScrollableCursorErr.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_157b_FetchAssocScrollableCursor_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_157_FetchAssocScrollableCursor_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_158_FetchAssocNestedSelects_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_159a_FetchAssocSeveralRows_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_159_FetchAssocSeveralRows_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_160_FetchBoth.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_161_FetchBothNestedSelects_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_162_FetchBothNestedSelects_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_180_StmtErrMsg.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_190_ColumnsTable_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_191_ColumnsTable_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_195_InsertRetrieveXMLData_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_196_InsertRetrieveXMLData_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_197_StatisticsIndexes.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_200_MultipleRsltsetsUniformColDefs.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_201_MultipleRsltsetsDiffColDefs.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_210_FieldDisplaySize_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_211_FieldDisplaySize_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_212_FieldDisplaySize_03.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_213_FieldDisplaySize_04.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_220_PersistentConn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_221_100PersistentConns.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_230_FieldTypePos.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_231_FieldTypeName.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_232_FieldTypePosName.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_240_FieldWidthPosName_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_241_FieldWidthPosName_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_250_FreeResult_01.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_251_FreeResult_02.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_260_FetchTupleMany_07.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_261_FetchObjectAccess.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_264_InsertRetrieveBIGINTTypeColumn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_265_NoAffectedRows.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_300_ServerInfo.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_310_ClientInfo.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_311_InsertSelectDeleteNumLiterals.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_52949_TestSPIntVarcharXml.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_6528_ScopingProblemBindParam.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_6561_InsertNULLValues.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_6755_ExtraNULLChar_ResultCLOBCol.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_6792_FieldTypeRetStrDatetimeTimestamp.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_createdbNX.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_createDropDB.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_cursortype.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_decfloat.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_decimal.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_execute_many.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_InsertRetrieveDateTimeTypeColumn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_recreateDB.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_setgetOption.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_trusted_context_connect.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_trusted_context_pconnect.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\test_warn.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests\__init__.py -> build\bdist.win-amd64\egg\tests
copying build\lib\tests.py -> build\bdist.win-amd64\egg
byte-compiling build\bdist.win-amd64\egg\certs\__init__.py to __init__.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\ibm_db.py to ibm_db.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\ibm_db_dbi.py to ibm_db_dbi.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\ibm_db_dlls\__init__.py to __init__.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\testfunctions.py to testfunctions.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_000_PrepareDb.py to test_000_PrepareDb.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_001_ConnDb.py to test_001_ConnDb.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_002_ConnDbUncatalogedConn.py to test_002_ConnDbUncatalogedConn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_003_NumAffectedRows.py to test_003_NumAffectedRows.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_004_ConnWrongUserPwd.py to test_004_ConnWrongUserPwd.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_005_ConnBadUserBadPwd.py to test_005_ConnBadUserBadPwd.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_006_ConnPassingOpts.py to test_006_ConnPassingOpts.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_007_pConnPassingOpts.py to test_007_pConnPassingOpts.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_008_ColumnInfo.py to test_008_ColumnInfo.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_010_UpdateRowCount.py to test_010_UpdateRowCount.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_011_DeleteRowCount.py to test_011_DeleteRowCount.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_012_KeysetDrivenCursorSelect01.py to test_012_KeysetDrivenCursorSelect01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_013_KeysetDrivenCursorSelect02.py to test_013_KeysetDrivenCursorSelect02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_014_KeysetDrivenCursorNegativeRow.py to test_014_KeysetDrivenCursorNegativeRow.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_015_InsertDeleteRowCount_01.py to test_015_InsertDeleteRowCount_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_016_InsertDeleteRowCount_02.py to test_016_InsertDeleteRowCount_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_017_selectRowcountPrefetchSTMTOpt.py to test_017_selectRowcountPrefetchSTMTOpt.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_018_selectRowcountPrefetchSetOpt.py to test_018_selectRowcountPrefetchSetOpt.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_019_selectRowcountPrefetchPrepOpt.py to test_019_selectRowcountPrefetchPrepOpt.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_020_RollbackDelete.py to test_020_RollbackDelete.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_021_CommitDelete.py to test_021_CommitDelete.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_022_RollbackInsert.py to test_022_RollbackInsert.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_023_ColumnPrivileges.py to test_023_ColumnPrivileges.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_024_ForeignKeys.py to test_024_ForeignKeys.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_025_PrimaryKeys.py to test_025_PrimaryKeys.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_030_Result.py to test_030_Result.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_031_ResultIndexPosition.py to test_031_ResultIndexPosition.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_032_ResultIndexName.py to test_032_ResultIndexName.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_033_ResultOutSequenceColumn.py to test_033_ResultOutSequenceColumn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_034_FetchAssoc.py to test_034_FetchAssoc.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_035_FetchRow_01.py to test_035_FetchRow_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_036_FetchRow_02.py to test_036_FetchRow_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_037_FetchRowIndexPos.py to test_037_FetchRowIndexPos.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_038_FetchRowIndexPosNested_01.py to test_038_FetchRowIndexPosNested_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_039_FetchRowIndexPosNested_02.py to test_039_FetchRowIndexPosNested_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_03a_ResultNonExistCol.py to test_03a_ResultNonExistCol.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_040_FetchTuple.py to test_040_FetchTuple.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_041_FetchTupleMany_01.py to test_041_FetchTupleMany_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_042_FetchTupleMany_02.py to test_042_FetchTupleMany_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_043_FetchTupleMany_03.py to test_043_FetchTupleMany_03.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_044_FetchTupleMany_04.py to test_044_FetchTupleMany_04.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_045_FetchTupleBinaryData_01.py to test_045_FetchTupleBinaryData_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_046_FetchTupleMany_05.py to test_046_FetchTupleMany_05.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_047_FetchTupleMany_06.py to test_047_FetchTupleMany_06.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_048_FetchTupleBinaryData_02.py to test_048_FetchTupleBinaryData_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_049_InsertNoneParam.py to test_049_InsertNoneParam.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_050_AutocommitStatus.py to test_050_AutocommitStatus.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_051_SetAutocommit_01.py to test_051_SetAutocommit_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_052_SetAutocommit_02.py to test_052_SetAutocommit_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_053_AttrThruConn.py to test_053_AttrThruConn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_054_CursorType.py to test_054_CursorType.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_060_Tables_01.py to test_060_Tables_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_061_Tables_02.py to test_061_Tables_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_062_Tables_03.py to test_062_Tables_03.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_063_Tables_04.py to test_063_Tables_04.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_064_Tables_05.py to test_064_Tables_05.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_065_FilterTableName.py to test_065_FilterTableName.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_066_TableObjects.py to test_066_TableObjects.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_070_Close.py to test_070_Close.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_071_CloseSuccess.py to test_071_CloseSuccess.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_080_ConnWrongDbAlias.py to test_080_ConnWrongDbAlias.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_081_ConnWrongUser.py to test_081_ConnWrongUser.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_082_ConnWrongPwd.py to test_082_ConnWrongPwd.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_090_ConnmsgWrongDbAlias.py to test_090_ConnmsgWrongDbAlias.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_091_ConnmsgWrongUser.py to test_091_ConnmsgWrongUser.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_092_ConnmsgWrongPwd.py to test_092_ConnmsgWrongPwd.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_100_SelectDeleteInsertFieldCount.py to test_100_SelectDeleteInsertFieldCount.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_101_InsertDeleteFieldCount.py to test_101_InsertDeleteFieldCount.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_102_NumFieldsSelect_01.py to test_102_NumFieldsSelect_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_103_NumFieldsSelect_02.py to test_103_NumFieldsSelect_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_110_FieldNum.py to test_110_FieldNum.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_111_FieldNumAddCol.py to test_111_FieldNumAddCol.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_112_FieldNumDiffCaseColNames.py to test_112_FieldNumDiffCaseColNames.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_113_DateTest.py to test_113_DateTest.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_114_NumericTest_01.py to test_114_NumericTest_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_115_NumericTest_02.py to test_115_NumericTest_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_116_ConnActive.py to test_116_ConnActive.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_120_FieldName.py to test_120_FieldName.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_121_FieldNameAddCol.py to test_121_FieldNameAddCol.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_122_FieldNameDiffCaseColNames.py to test_122_FieldNameDiffCaseColNames.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_123_FieldNamePos_01.py to test_123_FieldNamePos_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_124_FieldNamePos_02.py to test_124_FieldNamePos_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_125_FieldNamePos_03.py to test_125_FieldNamePos_03.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_130_PrepExecuteSelectStmt.py to test_130_PrepExecuteSelectStmt.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_131_PrepareExecuteSelectStatementParams.py to test_131_PrepareExecuteSelectStatementParams.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_132_ExecuteStatementArrayMultipleParams.py to test_132_ExecuteStatementArrayMultipleParams.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_133_ExecuteLongInputParams.py to test_133_ExecuteLongInputParams.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_140_BindParamSelectStmt.py to test_140_BindParamSelectStmt.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_141_BindParamSelectStmtMultipleParams_01.py to test_141_BindParamSelectStmtMultipleParams_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_142_BindParamSelectStmtMultipleParams_02.py to test_142_BindParamSelectStmtMultipleParams_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_143_BindParamInsertStmtNoneParam.py to test_143_BindParamInsertStmtNoneParam.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_144_BindParamInsertStmtPARAM_FILE.py to test_144_BindParamInsertStmtPARAM_FILE.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_145_BindRetrieveNoneEmptyString.py to test_145_BindRetrieveNoneEmptyString.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_146_CallSPINAndOUTParams.py to test_146_CallSPINAndOUTParams.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_147_PrepareWithWrongType.py to test_147_PrepareWithWrongType.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_148_CallSPDiffBindPattern_01.py to test_148_CallSPDiffBindPattern_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_150_FetchAssocSelect_01.py to test_150_FetchAssocSelect_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_151_FetchAssocSelect_02.py to test_151_FetchAssocSelect_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_152_FetchAssocSelect_03.py to test_152_FetchAssocSelect_03.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_153_FetchAssocSelect_04.py to test_153_FetchAssocSelect_04.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_154_AllFetches.py to test_154_AllFetches.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_155_FetchAssocSelect_05.py to test_155_FetchAssocSelect_05.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_156_FetchAssocNestedSelects_01.py to test_156_FetchAssocNestedSelects_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_157a_FetchAssocWithoutScrollableCursorErr.py to test_157a_FetchAssocWithoutScrollableCursorErr.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_157b_FetchAssocScrollableCursor_02.py to test_157b_FetchAssocScrollableCursor_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_157_FetchAssocScrollableCursor_01.py to test_157_FetchAssocScrollableCursor_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_158_FetchAssocNestedSelects_02.py to test_158_FetchAssocNestedSelects_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_159a_FetchAssocSeveralRows_02.py to test_159a_FetchAssocSeveralRows_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_159_FetchAssocSeveralRows_01.py to test_159_FetchAssocSeveralRows_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_160_FetchBoth.py to test_160_FetchBoth.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_161_FetchBothNestedSelects_01.py to test_161_FetchBothNestedSelects_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_162_FetchBothNestedSelects_02.py to test_162_FetchBothNestedSelects_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_180_StmtErrMsg.py to test_180_StmtErrMsg.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_190_ColumnsTable_01.py to test_190_ColumnsTable_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_191_ColumnsTable_02.py to test_191_ColumnsTable_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_195_InsertRetrieveXMLData_01.py to test_195_InsertRetrieveXMLData_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_196_InsertRetrieveXMLData_02.py to test_196_InsertRetrieveXMLData_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_197_StatisticsIndexes.py to test_197_StatisticsIndexes.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_200_MultipleRsltsetsUniformColDefs.py to test_200_MultipleRsltsetsUniformColDefs.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_201_MultipleRsltsetsDiffColDefs.py to test_201_MultipleRsltsetsDiffColDefs.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_210_FieldDisplaySize_01.py to test_210_FieldDisplaySize_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_211_FieldDisplaySize_02.py to test_211_FieldDisplaySize_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_212_FieldDisplaySize_03.py to test_212_FieldDisplaySize_03.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_213_FieldDisplaySize_04.py to test_213_FieldDisplaySize_04.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_220_PersistentConn.py to test_220_PersistentConn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_221_100PersistentConns.py to test_221_100PersistentConns.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_230_FieldTypePos.py to test_230_FieldTypePos.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_231_FieldTypeName.py to test_231_FieldTypeName.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_232_FieldTypePosName.py to test_232_FieldTypePosName.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_240_FieldWidthPosName_01.py to test_240_FieldWidthPosName_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_241_FieldWidthPosName_02.py to test_241_FieldWidthPosName_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_250_FreeResult_01.py to test_250_FreeResult_01.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_251_FreeResult_02.py to test_251_FreeResult_02.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_260_FetchTupleMany_07.py to test_260_FetchTupleMany_07.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_261_FetchObjectAccess.py to test_261_FetchObjectAccess.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_264_InsertRetrieveBIGINTTypeColumn.py to test_264_InsertRetrieveBIGINTTypeColumn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_265_NoAffectedRows.py to test_265_NoAffectedRows.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_300_ServerInfo.py to test_300_ServerInfo.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_310_ClientInfo.py to test_310_ClientInfo.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_311_InsertSelectDeleteNumLiterals.py to test_311_InsertSelectDeleteNumLiterals.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_52949_TestSPIntVarcharXml.py to test_52949_TestSPIntVarcharXml.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_6528_ScopingProblemBindParam.py to test_6528_ScopingProblemBindParam.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_6561_InsertNULLValues.py to test_6561_InsertNULLValues.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_6755_ExtraNULLChar_ResultCLOBCol.py to test_6755_ExtraNULLChar_ResultCLOBCol.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_6792_FieldTypeRetStrDatetimeTimestamp.py to test_6792_FieldTypeRetStrDatetimeTimestamp.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_createdbNX.py to test_createdbNX.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_createDropDB.py to test_createDropDB.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_cursortype.py to test_cursortype.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_decfloat.py to test_decfloat.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_decimal.py to test_decimal.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_execute_many.py to test_execute_many.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_InsertRetrieveDateTimeTypeColumn.py to test_InsertRetrieveDateTimeTypeColumn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_recreateDB.py to test_recreateDB.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_setgetOption.py to test_setgetOption.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_trusted_context_connect.py to test_trusted_context_connect.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_trusted_context_pconnect.py to test_trusted_context_pconnect.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\test_warn.py to test_warn.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests\__init__.py to __init__.cpython-37.pyc
byte-compiling build\bdist.win-amd64\egg\tests.py to tests.cpython-37.pyc
installing package data to build\bdist.win-amd64\egg
running install_data
copying README.md -> build\bdist.win-amd64\egg\
copying CHANGES -> build\bdist.win-amd64\egg\
copying LICENSE -> build\bdist.win-amd64\egg\
copying config.py.sample -> build\bdist.win-amd64\egg\
creating build\bdist.win-amd64\egg\EGG-INFO
copying ibm_db.egg-info\PKG-INFO -> build\bdist.win-amd64\egg\EGG-INFO
copying ibm_db.egg-info\SOURCES.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying ibm_db.egg-info\dependency_links.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying ibm_db.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-INFO
writing build\bdist.win-amd64\egg\EGG-INFO\native_libs.txt
zip_safe flag not set; analyzing archive contents...
__pycache__.ibm_db.cpython-37: module references __file__
__pycache__.testfunctions.cpython-37: module MAY be using inspect.stack
tests.__pycache__.test_000_PrepareDb.cpython-37: module references __file__
tests.__pycache__.test_144_BindParamInsertStmtPARAM_FILE.cpython-37: module references __file__
creating dist
creating 'dist\ibm_db-3.0.1-py3.7.egg' and adding 'build\bdist.win-amd64\egg' to it
removing 'build\bdist.win-amd64\egg' (and everything under it)
Processing ibm_db-3.0.1-py3.7.egg
creating d:\appdata\anaconda3\lib\site-packages\ibm_db-3.0.1-py3.7.egg
Extracting ibm_db-3.0.1-py3.7.egg to d:\appdata\anaconda3\lib\site-packages
Adding ibm-db 3.0.1 to easy-install.pth file

Installed d:\appdata\anaconda3\lib\site-packages\ibm_db-3.0.1-py3.7.egg
Processing dependencies for ibm-db==3.0.1
Finished processing dependencies for ibm-db==3.0.1

****************************************
You are downloading a package which includes the Python module for IBM DB2/Informix.  The module is licensed under the Apache License 2.0. The package also includes IBM ODBC and CLI Driver from IBM, which is automatically downloaded as the python module is installed on your system/device. The license agreement to the IBM ODBC and CLI Driver is available in D:\AppData\anaconda3\Lib\site-packages\clidriver or D:\AppData\anaconda3\Lib\site-packages\ibm_db-3.0.1-py3.7.egg\clidriver.   Check for additional dependencies, which may come with their own license agreement(s). Your use of the components of the package and dependencies constitutes your acceptance of their respective license agreements. If you do not accept the terms of any license agreement(s), then delete the relevant component(s) from your device.
****************************************

D:\study\python\sample\ibm_db-3.0.1>

 

 

二、使用ibm_db模块

1.查询数据使用方法：

#!/usr/bin/python
# -*-encoding:utf-8-*-

import ibm_db
import logging

dbinfo = ("DATABASE=DBNAME:HOSTNAME=192.168.1.1:PORT=50000:PROTOCOL=TCPIP:UID=username:PWD=password") #数据库信息
sql = "select * from table;"
class db2Cfg():  #创建获取数据库信息的类
    def __init__(self,dbinfo):
        self.conn_info = dbinfo  #

    def getInfo(self,sql):
        try:
            conn = ibm_db.connect(self.conn_info,"","")  #连接数据库
        except:
            logging.error("connect failed")
        else:
            sql_exec = sql
            logging.info(sql_exec)

            try:
                stmt = ibm_db.exec_immediate(conn,sql_exec)  #执行sql
                result = ibm_db.fetch_both(stmt)  #将sql返回的第一行数据存入result，result是一个二维数组

                result_list = []  #定义列表存放所有结果
                while result:
                    ###循环获取sql返回的所有数据###
                    result_list.append([result[0],result[1]]) #sql返回多少个字段，就按照列表索引进行获取，本例中是假设返回两个字段
                    result = ibm_db.fetch_both(stmt)
            except Exception as err:
                print("stmt faild,%s"% repr(err))

            finally:
                if ibm_db.active(conn):
                    ibm_db.close(conn)
                logging.info("database closed success")



(sql_info) = db2Cfg(dbinfo).getInfo(sql) #调用方法获取最终结果

 2.插入数据使用方法，在插入数据时，由于python是强类型的语言，所以即使是数字也需要把列表处理为字符串的形式，以下用法给出了向数据库内插入数据的用法，这里考虑到数据量大的情况，为了提升效率，对数据进行了分片处理，每次插入200条数据，详细代码如下：

def ins_data(ins_data_list):
    ###可以对数据进行处理，取决于实际需求###
    dbinfo = "DATABASE=DBNAME:HOSTNAME=192.168.1.1:PORT=50000:PROTOCOL=TCPIP:UID=username:PWD=password"
    try:
        conn = ibm_db.connect(dbinfo,'','')  #连接数据库
    except:
        print("connect faild,%s "% ibm_db.conn_errormesg())
    else:
        del_sql = "delete from table;"
        try:
            stmt = ibm_db.exec_immediate(conn,del_sql)
        except:
            print(ibm_db.stmt_errormsg())
        else:
            max_value = 200  #设定每次最多插入200条数据
            x=len(ins_data_list)//max_value + 1 #按照每次200条对数据进行分片，不足200按实际条数算
                                                #这里默认数据是单维数组，如果是二维数组的化需要进行降维处理
            #假设是二维数组，进行降维处理
            # ins_data_list_2 = []
            # for y in ins_data_list:
            #     ins_data_list_2.append(str(y).replace('[','').replace(']',''))

            for i in range:
                value_string ='),('.join(ins_data_list[max_value*(i):max_value*(i+1)])  #拼接值串，对值进行分片处理
                sql_string="insert into table values (" + value_string + ")"  #拼接插入语句
                try:
                    stmt =ibm_db.exec_immediate(conn,sql_string) #执行插入语句
                except:
                    print(ibm_db.stmt_errormsg())
    finally:
        if ibm_db.active(conn):
            ibm_db.close(conn)

 

以上，就是关于ibm_db模块的安装及简单使用，仅以记录作为学习分享。