Re: [IBMiOSS] dbtoxlsx.py / PASE QShell

Hi John,

Thanks for confirming that you've also come across this.

For the moment I think that the things I need to run might either already
be in an overnight batch job, or else be simple enough that I can run them
through QSH via a simple wrapper.

If I decide I can't run things interactively, rather than submit jobs I'd
probably build it into some asynchronous server code I already have.

thanks again,
Craig

On 30 August 2018 at 15:06, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

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.
--
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: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource.