Re: [IBMiOSS] dbtoxlsx.py / PASE QShell

I can confirm that the Python DB connector is server-mode only.

If interested in pursuing SBMJOB, I use this script quite often to do
SBMJOB of PASE workloads:
https://github.com/ThePrez/IBMiOSS-utils/blob/master/sbmjob.sh
Nothing magic here, but it might save you a minute or two. (I also use it
as an example of how to call shell-stuff with QP2SHELL, though QSH is
generally easier)


"OpenSource" <opensource-bounces@xxxxxxxxxxxx> wrote on 08/30/2018
09:06:33 AM:

From: John Yeung <gallium.arsenide@xxxxxxxxx>
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Date: 08/30/2018 09:07 AM
Subject: Re: [IBMiOSS] dbtoxlsx.py / PASE QShell
Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxx>

I am confident your suspicion about SQL server mode is correct. I've
come across it myself with iSeriesPython.

How I've come to cope with it is to always submit a new job to run
Python. I mean, from the 5250, interactive use is pretty crappy
anyway, so I've tailored both my Python scripts and my own workflow
habits to be centered around SBMJOB.

You may want to make a generic wrapper which you always use for all
your Python calls, and have that wrapper handle everything that's
needed, including submitting a new job. (For me, that also includes
setting ALWMLTTHD(*YES).)

John Y.