Re: Where do I find documentation on /plugin=cldownload as per Scott Forsties example of Generating spreadsheets with SQL.sql -- MIDRANGE-L

Yep running 1.1.8.4 in 'Run SQL Scripts'
'out of the right directory' What is the right directory?
I did the install and know that we don't have any 'corporate
approved examples'.
I have added a few personal Script examples and have a path to them defined
in the preferences.
Do I need to do some sort of download from the IBMi?

On Thu, Jul 9, 2020 at 1:59 PM Rob Berendt <rob@xxxxxxxxx> wrote:

The first thing I would check is that Run SQL Scripts itself shows
1.1.8.4. It's very common, accidentally or otherwise, for people to have
multiple versions installed on their laptops and you want to be sure you're
running the right one.
The next thing I would check is that you're running the examples out of
the right directory and not set to some corporate approved examples share
or some such thing that is rather dated.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of K
Crawford
Sent: Thursday, July 9, 2020 2:09 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: 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.

Tim you said " if you open Run SQL Scripts, and click on the Insert from
examples button. Search for 'Spreadsheet'"
I have tried this and no hits on the 'Spreadsheet' search.
I am running 1.1.8.4
What am I missing?

Kerwin C.

On Thu, Jul 9, 2020 at 7:45 AM Tim Rowe <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 <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Don
Brown via MIDRANGE-L
Sent: Wednesday, July 8, 2020 6:06 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Don Brown <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-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-generating-spreadsheets-with-sql-sql-L1

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
KCrawford
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com