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

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

On Thu, Nov 2, 2023 at 4:20 PM Dan <dan27649@xxxxxxxxx> wrote:

I am aware that one can use ? in a script to be prompted. I have a
script from an SQLRPGLE program that I am trying to test in ACS Run
SQL Scripts; it uses a few variables several times. I would like to
be prompted once for each variable. For example:

select * from testfile a
where a.DistrictA = :inDistrict or a.DistrictB = :inDistrict
and a.Region = :inRegion;

The above is a simplified example from the one I am using where
:inDistrict is used seven times in the script. How can I be prompted
once for :inDistrict and once for :inRegion?

I tried SET and DECLARE, but those were just WAGs. Google was not my
friend, but I'm not sure I'm even searching on the right terms.

- Dan

--
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.