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

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