RE: Variable in ACS SQL

Thank you.

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

http://ibm.biz/IBMi_ACS should direct you to download.

also available via PTF
R730 SI83448
R740 SI83385
R750 SI83449

Bryan


Therrien, Paul via MIDRANGE-L wrote on 5/10/2023 12:25 PM:

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