Re: Run SQL Scripts: Define variables whose values are prompted

[Dan <dan27649@xxxxxxxxx>]

I was not aware!  Thanks for that tip!

I agree that that is a mess.  Does this mean I can create the variable in
one session and another user can use that same variable?  This really
should be created in QTEMP.

- Dan

On Thu, Nov 2, 2023 at 5:00 PM <smith5646midrange@xxxxxxxxx> wrote:

> Be aware that when I do this it creates a "*SRVPGM" with that name in
> QGPL.
>
> I would be interested to know if there is a way to change the library so
> it creates it in QTEMP and it automatically gets cleaned up.
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dan
> Sent: Thursday, November 2, 2023 4:55 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: Re: Run SQL Scripts: Define variables whose values are prompted
>
> After refining my search, I found I can use:
> CREATE OR REPLACE VARIABLE @inDistrict char default 'WAZ'; CREATE OR
> REPLACE VARIABLE @inRegion char default 'C12'; then change the :in*
> references to @in*.  This works for me.
>
> - Dan