Aha ... my experience is that advanced APIs and frameworks (starting with
j2EE) can complicate matters considerably in pursuit of simplification :)

In any case, one hopes that the ODBC connector provided with iACS suffices,
at some level of Django abstraction.

On Wed, Nov 18, 2020 at 10:35 AM Roberto José Etcheverry Romero <
yggdrasil.raiker@xxxxxxxxx> wrote:

I think the problem lies in whether or not Django's ORM has support for DB2
for i. Django abstracts the DB using that ORM to simplify the programmers'
life.

On Wed, 18 Nov 2020 at 13:29, Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

You mean, effectively, connect from Python, correct?
*ODBC* for choice.
Driver comes in the Application Package with iACS.

On Wed, Nov 18, 2020 at 8:24 AM Quintin Holmberg <
qholmberg@xxxxxxxxxxxxxxxx>
wrote:


For those of you who are, what method did you use to connect to the
IBMi
databases?


Here's my (sanitized) .odbc.ini on my workstation:

[IEXAMPLE]
Description=IBM i Access ODBC Driver
Driver=IBM i Access ODBC Driver
System=iexample.example.com
UserID=jwoehr
Password=foobar2u
Naming=0
DefaultLibraries=QGPL
Database=A1234567
ConnectionType=0
CommitMode=2
ExtendedDynamic=1
DefaultPkgLibrary=QGPL
DefaultPackage=A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression=1
MaxFieldLength=32
BlockFetch=1
BlockSizeKB=128
ExtendedColInfo=0
LibraryView=ENU
AllowUnsupportedChar=0
ForceTranslation=0
Trace=0

Here's a connect example:

import pyodbc

cn = pyodbc.connect("DSN=IEXAMPLE")
cursor = cn.cursor()
cursor.tables()
rows = cursor.fetchall()
for row in rows:
print(row.table_name)
cursor.close()

cursor = cn.cursor()
try:
cursor.execute("Select * from ICECREAMP") # in default library QGPL
(see odbc.ini above)
rows = cursor.fetchall()
for row in rows:
print(row)
except:
print('cursor.execute("Select * from ICECREAMP") didn''t work.')
finally:
cursor.close()
--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and delete/destroy
all copies of this communication immediately.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com




This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].