1 2 3 4 5 | LIBPATH=/opt/odbc_7.1/lib:/opt/netezza/lib64: DB2LIBPATH=/opt/odbc_7.1/lib:/opt/netezza/lib64: LD_LIBRARY_PATH=/opt/odbc_7.1/lib:/opt/netezza/lib64: NZ_ODBC_INI_PATH=/home/bigsql/sqllib/cfg ODBCINST=/home/bigsql/sqllib/cfg/odbc.ini |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [ODBC Data Sources] NZSQL = NetezzaSQL [NZSQL] Driver = /opt/netezza/lib64/libnzodbc.so Description = NetezzaSQL ODBC Servername = 192.168.0.3 Port = 5480 Database = TESTDB Username = netuser Password = netpassword [ODBC] IANAAppCodePage=4 InstallDir=/opt/odbc_7.1.6 Trace=0 TraceDll=/opt/odbc_7.1.6/lib/FOtrc27.so TraceFile=odbctrace.out UseCursorLib=0 |
1 2 3 4 | LIBPATH=/opt/odbc_7.1/lib: DB2LIBPATH=/opt/odbc_7.1/lib: LD_LIBRARY_PATH=/opt/odbc_7.1/lib: DJX_ODBC_LIBRARY_PATH=/opt/odbc_7.1/lib: |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [mssql2012csdl3] Driver=/opt/odbc_7.1/lib/FOsqls27.so Description=SQL Server IBM-Branded Driver Database=mssql2012db3 Address=192.168.0.4,1433 [mssql2016csdl1] Driver=/opt/odbc_7.1/lib/FOsqls27.so Description=DataDirect 7.1 SQL Server Wire Protocol Database=mssql2016db1 Address=192.168.0.5,1433 [ODBC] IANAAppCodePage=4 InstallDir=/opt/odbc_7.1/lib/ Trace=0 TraceDll=/opt/odbc_7.1/lib/FOtrc27.so TraceFile=odbctrace.out UseCursorLib=0 |
1 2 3 4 | CREATE WRAPPER DRDA; DROP WRAPPER DRDA; CREATE WRAPPER DRDA OPTIONS (DB2_FENCED 'Y'); CREATE WRAPPER MYDRDA LIBRARY 'libdb2drda.so'; |
1 2 3 4 | CREATE WRAPPER TERADATA; DROP WRAPPER TERADATA; CREATE WRAPPER TERADATA OPTIONS (DB2_FENCED 'Y'); CREATE WRAPPER MYTERADATA LIBRARY 'libdb2teradata.so'; |
1 2 3 | CREATE WRAPPER ODBC OPTIONS (MODULE '/usr/ibmpacks/bigsql/4.2.5.0/db2/federation/odbc/lib/libodbc.so'); DROP WRAPPER MYODBC; CREATE WRAPPER MYODBC LIBRARY 'libdb2rcodbc.so' OPTIONS (MODULE '/usr/ibmpacks/bigsql/4.2.5.0/db2/federation/odbc/lib/libodbc.so'); |
1 2 | ALTER WRAPPER DRDA OPTIONS (SET DB2_FENCED 'N'); ALTER WRAPPER ODBC OPTIONS(SET DB2_FENCED 'Y', SET MODULE '/opt/odbc7.1/lib/libodbc.so'); |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |