Re: Creating host variables in QTEMP using RSS

[Charles Wilt <charles.wilt@xxxxxxxxx>]

QTEMP would be unique to each connection...

Not sure how that'd be useful to multiple people.

Charles

On Wed, Oct 8, 2025 at 10:52 AM Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx>
wrote:

> Seems I learn something new every day in SQL / RSS.  Today, I discovered I
> can do this in a script:
>
> create variable dbale/testvar varchar(30);
> set testvar = 'PRD09A';
> select * from ACXDSPPRB where Server = testvar ;
>
> Originally, I had a colon in front of testvar on the select statement, but
> RSS prompted me for a value instead of using the value I set in the prior
> statement.  It would be nice if I could use the colon so that I can easily
> copy the statement into RPG and not have to remember to prefix all host
> variables with ':' after I paste it into the RPG source.  I'm guessing
> there's no way around this, but I would love to be surprised.
>
> Also, IBM explicitly prohibits creating a variable in QTEMP.  Bleahh.
> This would be extremely useful for RSS scripts that are used by multiple
> people simultaneously.  Can anyone think of a reason why this shouldn't be
> allowed, at least for RSS scripts?  If I don't hear any reasonable
> objections, I'll create an idea for it.
>
> - Dan Bale
> *** CONFIDENTIALITY NOTICE: The information contained in this
> communication may be confidential, and is intended only for the use of the
> recipients named above. If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, distribution, or
> copying of this communication, or any of its contents, is strictly
> prohibited. If you have received this communication in error, please return
> it to the sender immediately and delete the original message and any copy
> of it from your computer system. If you have any questions concerning this
> message, please contact the sender. ***
> --
> 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.