On Sun, Oct 10, 2021 at 12:20 AM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

though honestly just jumping in with Python on IBM
i wouldn't be wrong.


Yes. Aside from some convenience IDE tools that are challenging to use on
the IBM i, Python works the same on the i as Linux.

I actually don't think I use Python as Jack describes


Yes, again, if it gets into numeric calculation or string operations, I
immediately delegate to Python.
FOR NEW STUFF.
I still maintain old scripts (30 years old?) in CL.

Python is a good choice for the "create an Excel workbook and email it
to the recipient" portion of a report job.


Yes, Python is the scripting gateway to a lot of powerful open source stuff
that comes from the Linux world.

Python is, in my opinion, a much better SQL host language than RPG,
and I use it as such.


import pyodbc
connection = pyodbc.connect("DSN=MYIBMi")
cursor = connection.cursor()
cursor.execute("SELECT * FROM FOO.BAR")
for row in cursor.fetchall():
print(row)
cursor.close()
connection.close()


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.