I agree prompting for the same name multiple times is pretty weird.I think , as a basis, they (IBM) should just copy how for example other tools like SQLWorkbench/J (free and open source excellent tool to work with any JDBC, I use it all the time also against DB2i and other databases, very neat the connection profile) do... i.e. can memorize the last value, even obtain a default value of a variable by executing a sql statement, etc.
On Thursday, October 9, 2025 at 02:43:38 AM GMT+2, Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx> wrote:
You mean, like this one?
https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4640
- Dan Bale
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vern Hamberg via RPG400-L
Sent: Wednesday, October 8, 2025 5:51 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Subject: Re: Inconsistency with SQL in ACS vs RPG
Hi all
We can also save the SQL that contains host variables or parameter markers - it's just a text file.
Daniel, I'm also not happy that I have to enter a value for each instance of a host variable. I go back to how it works in QMQRY, the same substitution string needs the value entered only one time. I know, different interface.
But one of us should submit an Idea for this to change. I'll look to see if there might already be one, maybe submit it myself - what a concept, eh? :)
*Regards*
*Vern Hamberg*
IBM Champion 2025 <cid:part1.LsaXZnYN.v6TSW8cA@centurylink.net> CAAC (COMMON Americas Advisory Council) IBM Influencer 2023
On 10/8/2025 9:09 AM, dfreinkel@xxxxxxxxxxxxxxxxx wrote:
Daniel
In RSS try creating variables first and then populate the variables with a SET statement.
You can then save the SQL for later use and you will not have to re-enter any values.
Darryl Freinkel
A4G
Telephone: 770.321.8562
-----Original Message-----
From: RPG400-L<rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Daniel Gross
Sent: Wednesday, October 8, 2025 8:49 AM
To:rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Inconsistency with SQL in ACS vs RPG
I do that occasionally - but sadly the pseudo-host-variables in iACs are ...
a) not persistent - so I have to re-enter them at every execution
again and again - VScode DB2 for I has a new "bind:" prefix - I have
to look into this
b) if you have the same host-variable multiple times, you have to
enter it multiple times - which is also less than ideal
But all in all I use that feature here and there.
Regards,
Daniel
*** 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. ***
As an Amazon Associate we earn from qualifying purchases.