Free method of connecting to IBMi DB2 with Python?

I’m using ibm_db and ibm_db_dbi at the moment, but they’re getting rejected due to license requirement (yeah wtf).

Wondering if there’s a similar package in Python that’s easy to implement without beating around a jungle to connect to an IBMi server DB2 and without license requirements

EDIT:

u/MasterOfIBMi is LEGIT. Got this working in 5 minutes.

import pyodbc connection = pyodbc.connect( Driver='{IBM i Access ODBC Driver}’, SYSTEM=’someserver’, UserID=”, Password=”) cur = connection.cursor() cur.execute(“select * from sysibm.sysdummy1”) row = cur.fetchone() while row: print(row[0]) row = cur.fetchone() exit()

submitted by /u/tallburnik
[link][comments]

IBM i ISVs Mark the ? for February 17th @TimRowe_IBMi and the IBM i product management team will be hosting a webinar for our IBM i ISV community on virtual serial number enablement and the new Navigator for i. Register here:

IBM i ISVs
Mark the ? for February 17th @TimRowe_IBMi and the IBM i product management team will be hosting a webinar for our IBM i ISV community on virtual serial number enablement and the new Navigator for i. Register here: ibm.biz/Bdft5L

– Brandon Pederson (@BPED07)07:28 – Jan 28, 2022

@IBMJesseG @kadlerio what if… most QSYS commands could use piping enabling to use something like: system “savlib QGPL *STOUD” | gzip -9 | aws s3 cp – s3://ICOSBucket/QGPL.gz ? (RFE was already opened) #ibmi #ibmioss #as400 #iseries #powersystems

@IBMJesseG @kadlerio what if… most QSYS commands could use piping enabling to use something like:

system “savlib QGPL *STOUD” | gzip -9 | aws s3 cp – s3://ICOSBucket/QGPL.gz

?

(RFE was already opened)#ibmi #ibmioss #as400 #iseries #powersystems

– Hector Servadac (@hserva) (in reply to IBMJesseG)10:26 – Jan 28, 2022

Verified by MonsterInsights