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

I'm pretty sure there's a TAATOOL routine that would obviate the need for all of this coding.

https://www.taatool.com/


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, September 13, 2023 6:11 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Two questions, Re: Getting rid of jobs and spool files

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> 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> 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 To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: 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 for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: 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
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact 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 To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: 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 for any subscription related questions.