Re: Variable in ACS SQL

[VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>]

Very nice gift we got at 9.2! My post was more about before that.


Maybe another option would be this -

select * from mytable where mydate between :fromdate and :todate


Then, in the messages after running the statement, the values entered are listed with their names


Cheers
Vern


On Wed, 10 May, 2023 at 10:49 AM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:
 

To: midrange-l@xxxxxxxxxxxxxxxxxx

if you have the latest ACS 1.1.9.2, in RunSQLScripts you can do what you 
are asking.

select * from mytable where mydate between ? and ?

when you run that SQL in the RSS window it will prompt you for the 
variables you want to use.

https://www.ibm.com/support/pages/ibm-i-access-acs-updates


Bryan


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