Re: Variable in ACS SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Greg

Global variables are a great thing in ACS/RSS. But, as others also have 
mentioned, with the latest ACS, we don't need to create variables 
anymore. We can now directly use host variables like :FDATE or just a 
parameter marker such as ? - when you run the statement, a window pops 
up where we can enter a value for each one. Even more, after the 
statement runs, the Messages tab has the values listed that you entered. 
Very cool stuff from the I-Team!!

You can even just make "host" variables in RSS - they don't have to come 
from some embedded SQL in RPG source. Lovin'it!!

I did run into a statement where I had to use a global variable - it was 
a pretty honkin' big statement! I had to check the version of ACS - it 
said 1.1.9.2 - so maybe i'll open a ticket on that one.

Vern

On 5/10/2023 10:24 PM, Gregory Martin wrote:
> I have done it by doing the following:
>
> Create Or Replace Variable @FDATE Integer Default 20220101;
> Create Or Replace Variable @TDATE Integer Default 20230430;
>
> Select * from mytable where mydate between @FDATE and @TDATE;
>
> Drop Variable @FDATE;
> Drop Variable @TDATE;
>
> Thanks,
> Greg Martin
> mailto:mr.gamartin@xxxxxxxxx
>
>
> On Wed, May 10, 2023 at 7:06 AM gio.cot via MIDRANGE-L <
> midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> > Hi all
> >
> > Suppose i have this Sql statement :
> >
> >
> >
> > select * from mytable where mydate between 20230101 and 20230430
> >
> > is it possibile define some variables (in ACS Script Sql)  and substite the
> > date with the variable defined ?
> >
> > example
> >
> >
> >
> > set date01 = 20230101
> >
> > set date02 = 20230430
> >
> > select * from mytable where mydate between date01 and date02
> >
> >
> >
> > Thanks in advance
> >
> >
> >
> >
> >
> >
> >
> > --
> > 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.