Re: Running multiple queries in ACS Run SQL Scripts

[Charles Wilt <charles.wilt@xxxxxxxxx>]

 Technically...

You wouldn't even need different names..
with TEMP as (...) select * from TEMP;
with TEMP as (...) select * from TEMP;
with TEMP as (...) select * from TEMP;

I personally would probably use CTE as a generic name here, but each to his
own.

Note that this is just for quick and dirty interactive stuff.

Production code, I use informative names for the CTEs..

Charles


On Wed, Feb 18, 2026 at 2:54 PM Stephen Landess <steve_landess@xxxxxxxxxxx>
wrote:

> Peter -
>
> That's what Charles suggested, and it works.  I was making it more
> difficult than it needed to be...
>
> Regards,
> Steve Landess
> (512) 289-0387
>
> ________________________________
> Peter wrote:
> Seems like you could also simply do
>
> With TEMP1 as
> (
> Select
> IMITM, IMLITM, IMDSC1, IMSTKT, IMSRP1, IMSRP2, IMSRP3, IMSRP4
> from BEHPROD.F4101
> where IMLITM = '1169091'
> )
> select * From temp1;
>
>
> With TEMP2 as
> (Select IBITM, IBMCU, IBLITM, IBSTKT, IBSRP1, IBSRP2, IBSRP3, IBSRP4
> from BEHPROD.F4102
> where IBLITM = '1169091'
> )
> select * From temp2;
>
> With TEMP3 as
> (
> select LIITM, LIMCU, IMLITM, LIPQOH
> from BEHPROD.F41021
> join BEHPROD.F4101
> on LIITM = IMITM
> where IMLITM = '1169091'
> )
> select * From temp3;
>
> --
> 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.