Save Results Sets to the IFS

The CAAC has reviewed this IBM Idea and recommends that IBM not implement this request. <<< state reason >>>

This can be done in SQL, using GENERATE_SPREADSHEET you may find information at: https://www.rpgpgm.com/2024/01/creating-excel-spreadsheets-with-sql.html

Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual IBM Ideas on the broader IBM i community and has therefore reviewed your Idea.

For more information about CAAC, see www.common.org/caac

Carmelita Ruvalcaba - CAAC Program Manager

We understand the request and will consider it for a future update though no commitment is made nor implied.

IBM Power Systems Development

There are a couple of issues with the CLDOWNLOAD plugin in addition to it not being user-friendly to leave the GUI and run a command line option in QSHELL:

1. There is no flag to set iASP - this means all SQL will need to be fully qualified in three part notation <DB>.<LIBRARY>.<TABLE> - SQL crafted in Run SQL Scripts would have to be amended before it could be run

2. Only one SQL statement can be run - whereas Run SQL Scripts allows several with a final results set being generated - CLDOWNLOAD could be run multiple times but would each connection be guaranteed to be serviced by the same server job (e.g. with the same QTEMP?)

3. Additional server-side setup required for configuration

I have also investigated the QSH db2 utility but the output format of this command is not suitable..

The specific scenario we are working with is ACS being delivered via Citrix. ACS users do not have easy access to the local filesystem on the Citrix server, and performance saving to a network drive is very poor (5 minutes+ to save a 70-100 record result set from a simple select statement on a small table).

I will investigate the CLDOWNLOAD plugin option, but it will probably require some development to create a user-friendly wrapper around it as a command line utility will be difficult to get ACS users to adopt.

Thank you for submitting your Idea to enhance IBM i Access Client Solutions (ACS). To save the Run SQL Scripts results to the IBM i IFS, you can map a network drive to a network share on the IBM i and then select the location you would like to save the results. If the requirement is to keep the data on the host server for security purposes, then you should consider running the CLDOWNLOAD plugin directly on the IBM i and direct the results to a file in the IFS. See https://www.ibm.com/support/pages/ibm-i-access-acs-getting-started#9.1.17

If neither of these options meet the requirement, please explain.

IBM Power Systems Development