Bob,
Start out at:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzahg/welcome.htm
See the 7.3 above?
Now use the search at the top right and enter in create variable. Pick the first hit. It will show CREATE VARIABLE.
Now look for the pull down bar for "Change version or product". Pick 7.1. It will find CREATE VARIABLE there also. It will start out with
|
Which generally indicates new function.
See also the 7.1 DB2 reference for what's new at
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzwhatsnew.htm
Notice: Global variables.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bob Cagle
Sent: Monday, January 21, 2019 3:13 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: iACS Run SQL Scripts
Yes, a temporary variable just for the script. Would be useful for ad-hoc stuff.
Was this available at 7.1? We just migrated to 7.3 this weekend. Just tried it in one of my scripts and it worked great.
Thanks
Bob
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Salsman, Michael
Sent: Monday, January 21, 2019 11:03 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: iACS Run SQL Scripts
Bob,
Are you talking about a temporary variable inside Run SQL Scripts to use during the session?
If so, you can use "Create Variable [name] [type] default [value]"
Then change it around using "Set [name] = [value]"
It should stay valid during the remainder of the session in any SQL statement made.
Michael Salsman
WinCo Foods, LLC
Programmer
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Bob Cagle
Sent: Monday, January 21, 2019 09:04
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: iACS Run SQL Scripts
I don't think it's possible to create a variable "on-the-fly" inside Run SQL Scripts. If I'm wrong about that, I'd also be interested in know how to accomplish this.
Thanks
Bob Cagle
IT Manager
Lynk
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Don Brown
Sent: Monday, January 21, 2019 2:29 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: iACS Run SQL Scripts
After some of Rob's comments I have been playing with the iACS Run SQL Scripts and have been having great fun.
I now wanted to set up a script that has a variable defined for a date.
The error I am getting with this is as follows; SQL State: 42601 Vendor Code: -29 Message: [SQL0029] INTO clause missing
from embedded statement. Cause . . . . . : SELECT and VALUES INTO
statements embedded in a program must have an INTO clause to specify where
the results of the statement are to be placed. Recovery . . . : Add the
INTO clause to the statement and try the request again.
Here is the simplified version of the SQL
begin
declare @PeriodEnd integer;
set @PeriodEnd =
20180901;
select OD.LODTPL as Rego,
LI.TSLTSL as TSL,
LI.TSLOSD as
Start_Date,
OD.LODOED as
End_Date
from scccdbdta/CDBTSLPF LI
where LI.TSLLTY not in ('TST','LIM','ST') and
LI.TSLSTD > @PeriodEnd
order by LI.TSLTSL;
end;
Any suggestions greatly appreciated as google is not my friend today.
Thanks
Don Brown
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
