Re: Inconsistency with SQL in ACS vs RPG

[David Gibbs <david@xxxxxxxxxxxx>]

On Wed, Oct 8, 2025 at 7:43 AM Vern Hamberg via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

> And I believe we can type in parameter markers, and RSS will prompt you
> for a value for each. As I recall, you can specify data types for each,
> too.

Yes, you can.

Just prefix the variable name with a colon.

For example.

select *
from abc
where field1 = :value1

It's a nice feature, although it doesn't remember previously entered values.

Also, if you use the same variable name more than once, it the prompt will
include it multiple times instead of prompting once and using the same
value for each instance.

david