1) Within Run SQL Scripts select Edit -> Preferences. 2) Select the General tab on the Preferences dialog box. 3) Select (check) Enable saving or results using scrollable cursors. 4) Restart your Run SQL Scripts connection. 5) Run your query. 6) Right click on those results and the option to Save Results is now available.

Oct 4, 2019 · It will be nice if it was possible to directly export the result set show in in the grid to common used formats like Excel ( Open XML) , CSV, plain XML, JSON and XHTML to name a few. The idea is to add a "Export" option in the context menu in the resultset.

This document steps through downloading a IBM i file directly into an Excel Spreadsheet by using Access Client Solutions data transfer from IBM i.

Apr 19, 2022 · Use Access Client Solutions (ACS) to download that output file to an Excel file on your PC. With the ACS Run SQL Scripts feature, though, you can make that process even easier. After running an SQL script to select your data, the output is displayed in the results window on the bottom portion of your screen.

Jan 9, 2024 · I've been using a functionality to run DB2 for i SQL statements directly from Excel spreadsheet. In order to do so, one must add an IBM i Access ODBC Driver to the list of User Data Sources in their PC. Then, in Excel, go to Data/Get Data/From Other Sources/From ODBC.

Mar 18, 2022 · Running this in the IBM i ACS SQL script explorer gives you the results in a nice spreadsheet friendly format: The trouble is – you cannot download those results to a spreadsheet by default because it only loads a page at a time.

Jan 5, 2020 · We all know we can use ACS Data Transfer Tool to export file and SQL result from IBM i to our PC/Mac … but not everyone knows that we can call the ACS Jar (acsbundle.jar) directly from IBM i and do greats tuffs in a batch job ….

Dec 11, 2017 · SELECT Export_Table.Equipment_Name, Export_Table.Task_No, Export_Table.Response, Export_Table.Notes, Export_Table.Tag_No FROM Export_Table WHERE (((Export_Table.Equipment_Name)="Pipe") AND ((Export_Table.Task_No)="A.1 Equipment") AND ((Export_Table.Tag_No)="scriptTest"));

Apr 21, 2017 · While IBM support tells us how to Save Result Data to .csv or .xls Files Using Run SQL Scripts in iSeries Navigator, in ACS the feature is grayed out. Just add these two lines to AcsConfig.properties file to enable save results:

Depending on which toolset you have available, you can export the resultset of the query to a delimited file, (if necessary performing any codepage conversion that may be needed), and then import that delimited file to Excel.