Re: Variable in ACS SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yes, it is easily done. The create variable statement is all you need

You might try looking at the examples - just press Ctrl-i and a window 
will open. Put variable in the text search box, I believe the create 
variable statement is there.

Cheers
Vern

On 5/10/2023 6:06 AM, gio.cot via MIDRANGE-L 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
>
>   
>
>   
>
>