Re: [IBMiOSS] IBM i python ibm_db_dbi example usage

[Jim Steil <jim@xxxxxxxxxxxxxxx>]

I was trying the same a couple weeks ago but was unsuccessful in getting
connected via ibm_db as well.  Got caught up in other work since and
haven't been able to get back to it.

-Jim

On Wed, Jul 6, 2016 at 2:59 PM, Jack Callahan <jjcllhn@xxxxxxxxx> wrote:

> I'd like to be able to create a python3 script that runs locally on an
> IBMi, reads a DB2 table and writes an .xlsx spreadsheet to the IFS.
>
> I've got python3 installed via 5733-OPS option 2, and used pip3 to set up
> ibm_db and xlsxwriter.
>
> Can anyone point me to a decent example that connects to the local IBMi DB2
> using ibm_db_dbi, and iterates over the result set? Looking for help
> mapping the connect method parameters.
>
> John Yueng provided a nice example for iSeriesPython on his blog, but that
> uses db2 rather than ibm_db
>
> http://iseriespython.blogspot.ca/2013/05/copy-physical-file-to-excel-in-9-lines.html
> .
> --
> This is the IBMi Open Source Roundtable (OpenSource) mailing list
> To post a message email: OpenSource@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/opensource
> or email: OpenSource-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/opensource.