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

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.