Re: ACS save sql results

Hi Charles

That plugin is for running a Data Transfer action - we had a recent thread discussing this - it does work.

But there is the cldownload plugin - with this you specify either a table name or a SELECT statement in the JAVA statement and it creates the workbook on the fly, no need or use for DTFX files.

I think Birgitta mentioned a Gist from Scott - he shows how to run the cldownload plugin in a stored procedure - but you can just do it with STRQSH from a command line, too.

Even cooler and more "eeeenteresting" than the Data Transfer options, IMHO.

Cheers
Vern

On 1/21/2022 8:08 AM, Charles Wilt wrote:

ACS can be run on the IBM i.
see https://www.ibm.com/support/pages/automating-acs-data-transfer

The bottom half shows
===> JAVA CLASS('/home/myUSRPRF/acsbundle.jar') PARM('/PLUGIN=logon'
'/SYSTEM=myIBMi' '/USERID=myUSRPRF' '/PASSWORD=xxxxxxx')

...and then:

===> JAVA CLASS('/home/myUSRPRF/acsbundle.jar') PARM('/PLUGIN=download'
'/USERID=myUSRPRF' 'testdt.dtfx')

Charles

On Fri, Jan 21, 2022 at 1:39 AM Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Hello,

I love using this feature to rapidly create an EXCEL file from any sql
result, but can it be used in a program on the i instead of CPYTOIMPF?

Thanks
--
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