python中建立连接以连接as400

安装IBM I Access Client Solutions -window application package

通过pyodbc包连接到DB2数据库

import pyodbc

connection = pyodbc.connect(
    Driver='{iSeries Access ODBC Driver}',
    System='ip/hostname',
    Uid='username',
    Pwd='password')
c1 = connection.cursor()

c1.execute('select * from libname.filename')
for row in c1:
    print (row)

c1.close()

connection.close()

或

import pyodbc

connection = pyodbc.connect(
    Driver='{iSeries Access ODBC Driver}',
    System='ip/hostname',
    Uid='username',
    Pwd='password',

    DBQ=library name,

    Extcolinfo=1

)
c1 = connection.cursor()

c1.execute('select * from filename')
for row in c1:
    print (row[0],row[1])

c1.close()

connection.close()

如果IBM被设置为允许这样做，那么可以在SQL中使用CALL调用QCMDEXC存储过程。例如,

c1.execute("call qcmdexc('crtlib lib(test)')")

QCMDEXC存储过程存储在QSYS2中(实际的程序对象是QSYS2/QCMDEXC1)，它的功能与QSYS中熟悉的同名程序大同小异，但存储过程专门用于通过SQL调用。

 

 

python connect to ibm as400 with java, pyodbc and itoolkit on windwos os

https://github.com/khaolek/as400-python