Re: Variable in ACS SQL

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.