Re: Two questions, Re: Getting rid of jobs and spool files

Yeah,SPL gives you more control of the process - the QCMDEXC function can be a bit scary, it does give you a success or failure response, but that's just informational. Still, a very neat addition.


Cheers


On Wed, 13 Sep, 2023 at 8:11 AM, Rob Berendt <robertowenberendt@xxxxxxxxx> wrote:


To: midrange systems technical discussion

Basically if you can do this:
select 'dltsplf...' concat myvariable concat ')' as mycmd from ...
you can now also do
select qcmdexc('dltsplf...' concat myvariable concat ')') from ...
Not bad. In fact many people had written their own QCMDEXC function while
waiting for IBM to come out with one.
I still prefer SPL for much of this though.

On Wed, Sep 13, 2023 at 8:48 AM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:

Hi Rob

An option now might be to use the QCMDEXC SQL function that lets you use
results of a SELECT directly in a command. A very cool - and dangerous -
addition to our panoply.

Cheers
Vern

On 9/13/2023 7:20 AM, Rob Berendt wrote:

Normally it's done by having the sql either output to another file or to

a

user space and then reading that. Again, qualifies as a "gyration".

That

is why I use SPL instead.

On Tue, Sep 12, 2023 at 7:20 PM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:

On 9/12/23 10:45 AM, Rob Berendt wrote:

I try to look at SQL's Stored Procedure Language or SPL as the new CL.
This mentality helps one to get over the gyrations it takes to

incorporate

SQL into CL.

It's possible to incorporate SQL into CL?!?

How?

--
JHHL

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related
questions.