brainchime.com Latest Questions

Admin
Asked: 2024-10-06T16:07:15+05:30 In:

Can i download the results as a file using the run sql script option on the ACS software?

I am using the Access client solution (ACS) software and opened up the Run SQL script option, ran the simple SQL select query, and selected the date from one of the files.

select * from libname.filename

Now, I want the SQL Select Excel spreadsheet downloaded in an Excel spreadsheet. When I am taking a right click on the resulting rows, I cannot see the download option. Only I can see the Save Results… option which is disabled. How can I enable this option? Also, whether this option downloads results in an Excel spreadsheet.

as400db2

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin

    the Save Results… option is by default disabled and you cannot download those results to an Excel spreadsheet by default because it only loads some rows at a time and you may have to press PAGE DOWN until you get all the data. This is a tedious task. You will see a message like 100 rows retrieved (more data available) on the bottom left corner of the Run SQL Script screen. You can enable the Save Results… option in a few steps that allow you to download the SQL result in an Excel spreadsheet using ACS Run SQL Script.

    1. Enable the Save Results… option that appears on Right-click on the SQL Result area which allows you to download data to Excel spreadsheets. For this, go to the Edit section in the top left corner click on that and that starts showing further options under the Edit section. Now click on the Preferences option under the Edit section. This will open the Preferences screen. Under the General Tab and below the New Connections heading check the Enable Saving of results option checkbox and click on Apply and OK.
    2. It will prompt a dialog saying Preferences Saved. The settings for the current connection differ from those specified for new connections. Do you want to apply these settings on the current connection? Click on Yes.
    3. Close the Run SQL script window and open it again. Run the SQL query again. That SQL query only fetched some rows of the table and more data is available to be loaded. So, please click on the little box in the bottom right corner of the Run SQL Script window to retrieve all rows.
    4. Since you have reopened the Run SQL Script and also ran the SQL query you will now see a download option named Save Results… is enabled under the Right click menu on the results area.
    5. Click on the Save Results… download option and download these SQL results as an Excel spreadsheet.
      Note: You can download results in other file formats as well such as .txt, .csv, .ods, .dsr, and tab-delimited text format.
    6. Once you click OK, the Excel spreadsheet file is downloaded/saved to the specified location, and an Inquiry message dialog box appears mentioning file has been saved successfully Would you like to open it. Click Yes to open the downloaded Excel spreadsheet file from the ACS Run SQL Script utility.