Re: [IBMiOSS] dbtoxlsx.py / PASE QShell

[Craig Richards <craig@xxxxxxxxxxxxxxxx>]

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.