<
https://www.ibm.com/support/pages/ibm-i-access-client-solutions>
https://www.ibm.com/support/pages/ibm-i-access-client-solutions
On Thu, 2020-07-09 at 08:57 -0400, frank boke wrote:
thanks alan but i’m still using cax i’ve not installed acs yet...wanna
gimme that link you accessed, i have a customer#...much appreciated, frank
On Thu, Jul 9, 2020 at 8:53 AM Alan Shore via MIDRANGE-L <
<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
midrange-l@xxxxxxxxxxxxxxxxxx
wrote:
Hi Frank
You can do that from the version of ACS that you have
Open ACS and press Help, then check for updates then download now
You will need an IBM id
Just did that yesterday
Alan Shore
E-mail :
<mailto:ASHORE@xxxxxxxx>
ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:
<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
midrange-l-bounces@xxxxxxxxxxxxxxxxxx
] On Behalf
Of frank boke
Sent: Thursday, July 9, 2020 8:49 AM
To: Midrange Systems Technical Discussion <
<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
midrange-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: Where do I find documentation on
/plugin=cldownload as per Scott Forsties example of Generating spreadsheets
with SQL.sql
hi, is their a link to get the latest acs version and service pack for it?
frank
On Thu, Jul 9, 2020 at 8:45 AM Tim Rowe <
<mailto:timmr@xxxxxxxxxx>
timmr@xxxxxxxxxx
wrote:
Greetings.
If you have the latest version of ACS, and you have the latest PTFs
installed on your IBM I, if you open Run SQL Scripts, and click on the
Insert from examples button. Search for 'Spreadsheet'
There are a couple of shipped examples for creating the
spreadsheets, the
latest has basically what you are trying to do created for you.
In the details of what you are showing below, the plugin name was not
correct and you need to have the SQL wrapped in a ' " ' double
quote.
Try some of those examples, and let me know if that works
-----Original Message-----
From: MIDRANGE-L <
<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
midrange-l-bounces@xxxxxxxxxxxxxxxxxx
On Behalf
Of Don
Brown via MIDRANGE-L
Sent: Wednesday, July 8, 2020 6:06 PM
To:
<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Don Brown <
<mailto:DBrown@xxxxxxxxxx>
DBrown@xxxxxxxxxx
Subject: Where do I find documentation on /plugin=cldownload as per
Scott
Forsties example of Generating spreadsheets with SQL.sql
CAUTION: This email originated from outside of the organization. Do
not
click links or open attachments unless you recognize the sender and
know
the content is safe.
I am trying to use Scott Forstie's sample from gist (
[1]
<
https://gist.github.com/forstie/2deda50658106461f650cd71917feff9#file>
https://gist.github.com/forstie/2deda50658106461f650cd71917feff9#file
-
generating-spreadsheets-with-sql-sql-L1
)
to generate and email a spreadsheet using the acsbundle.jar plugins
I could not get the full example to work so I am breaking it down into
pieces and the piece that uses /plugin=cldownload is failing with the
error MSGGEN037 - The specified plugin cannot be located
I looked at the getting started document for ACS version 1.1.8.4 and
it
does not have anything on this plugin.
Where do I find documentation on /plugin=cldownload ?
This is the statement I am trying to run in strqsh;
java -Dcom.ibm.iaccess.ActLikeExternal=true -jar
/home/acs/acsbundle.jar
/plugin=download /system=MSD820
/clientfile=/home/MSDDCB/systemnameGroupPTFCurrency
/sql=SELECT * FROM systools.group_ptf_currency
I have copied the acsbundle.jar into the directory /home/acs and this
is
version 1.1.8.4
System is V7R3
Thank you to any suggestions
Don
References
Visible links
1.
<
https://gist.github.com/forstie/2deda50658106461f650cd71917feff9#file>
https://gist.github.com/forstie/2deda50658106461f650cd71917feff9#file
-
generating-spreadsheets-with-sql-sql-L1
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email:
<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To
subscribe, unsubscribe, or change list options,
visit:
<
https://lists.midrange.com/mailman/listinfo/midrange-l>
https://lists.midrange.com/mailman/listinfo/midrange-l
or email:
<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
<
https://archive.midrange.com/midrange-l>
https://archive.midrange.com/midrange-l
.
Please contact
<mailto:support@xxxxxxxxxxxxxxxxxxxx>
support@xxxxxxxxxxxxxxxxxxxx
for any subscription
related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
<
https://amazon.midrange.com>
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email:
<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe,
unsubscribe, or change list options,
visit:
<
https://lists.midrange.com/mailman/listinfo/midrange-l>
https://lists.midrange.com/mailman/listinfo/midrange-l
or email:
<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
<
https://archive.midrange.com/midrange-l>
https://archive.midrange.com/midrange-l
.
Please contact
<mailto:support@xxxxxxxxxxxxxxxxxxxx>
support@xxxxxxxxxxxxxxxxxxxx
for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
<
https://amazon.midrange.com>
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:
<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
<
https://lists.midrange.com/mailman/listinfo/midrange-l>
https://lists.midrange.com/mailman/listinfo/midrange-l
or email:
<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
<
https://archive.midrange.com/midrange-l>
https://archive.midrange.com/midrange-l
.
Please contact
<mailto:support@xxxxxxxxxxxxxxxxxxxx>
support@xxxxxxxxxxxxxxxxxxxx
for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
<
https://amazon.midrange.com>
https://amazon.midrange.com
[
https://www.medtronsoftware.com/img/MedtronMinilogo.bmp] Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://www.medtronsoftware.com
CONFIDENTIALITY NOTICE
This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED. If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.
midrange.com
