Re: [IBMiOSS] dbtoxlsx.py / PASE QShell

Hi Jesse,

Thanks for your reply.

I'll certainly have a closer look at this if I go down the submit route.

I have to admit I made hard work of calling QP2Shell this morning before I
realised I was way over complicating it.

It's easy to waste a lot of time on some of this stuff, so I appreciate
your post.

regards,
Craig

On 30 August 2018 at 15:21, Jesse Gorzinski <jgorzins@xxxxxxxxxx> wrote:

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.

--
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.