Re: Variable in ACS SQL

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