Re: [IBMiOSS] Python 2 on IBM i 7.3 experience report

Hi, Buck,

Would you consider adding your utility to our “Python Examples for IBM i” Github repository?
https://github.com/Club-Seiden/python-for-IBM-i-examples <https://github.com/Club-Seiden/python-for-IBM-i-examples>

Thanks,
Alan
—
Alan Seiden
Principal, Seiden Group
The PHP on IBM i Experts



Project leader, Zend PHP Toolkit for IBM i
Zend Framework certified contributor

Office: 201-447-2437 Cell: 201-248-4704
http://www.seidengroup.com <http://www.seidengroup.com/> | alan@xxxxxxxxxxxxxxx <mailto:alan@xxxxxxxxxxxxxxx>
http://twitter.com/alanseiden <http://twitter.com/alanseiden>

On Mar 7, 2017, at 2:26 PM, Buck Calabro <kc2hiz@xxxxxxxxx <mailto:kc2hiz@xxxxxxxxx>> wrote:

I wrote an internal CL command that takes an SQL SELECT statement and
populates an XLSX spreadsheet file.
CMD -> CLP -> PASE -> Python -> Python script

It was quite easy; I had the general notion stubbed out and working with
print statements within minutes. pip install xlsxwriter worked a treat.
Working through the details took most of a day and that includes testing.

The Python script uses ibm_db to access DB2 for i. I used the new DB2
service UDTF qsys2.parse_statement() to extract the column names to be
used as the heading row. For 'select *' statements, this returns zero
columns, but the ibm_db2.columns() function will get the column names
from the table itself.

Error handling is very minimal; it's a tool that probably only I will use.

I was going to say that finding the documentation was kind of a pain,
but it's such a new domain to me that I can't judge until I've got used
to the new idiom.

Mixing CLP, Python, DB2, Excel, and the new DB2 services was very easy.
The only thing I wanted to do but didn't was to feed the exit code back
from Python to the CLP.

Altogether, quite a pleasant experience. I really like the short
feedback loop of an interpreted language.

--
--buck

Try wiki.midrange.com <http://wiki.midrange.com/>!

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

Thanks,
Alan
—
Alan Seiden
Principal, Seiden Group
The PHP on IBM i Experts



Project leader, Zend PHP Toolkit for IBM i
Zend Framework certified contributor

Office: 201-447-2437 Cell: 201-248-4704
http://www.seidengroup.com | alan@xxxxxxxxxxxxxxx
http://twitter.com/alanseiden