RE: Variable in ACS SQL

Well, this is funny ... to me at least.

Looking for latest ACS update and found none.
Went to the link provided by Bryan Dietz below and I see this:

General information about this update:
1. When using "Help->Check for Updates" to monitor IBM's web location for the next available update, this feature will not work for
versions prior to 1.1.9.2 because all ftp requests to this web location have been disabled.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan Dietz
Sent: Wednesday, May 10, 2023 11:49 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Variable in ACS SQL

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