Skip to Main Content
IBM Power Ideas Portal

This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on May 25, 2016

Allow save of returned values of SQL scripts

I would like to have the possibility to save the result of a SQL script to txt,csv,xls,... which was run in IBM i Access Client Solutions / run SQL scripts

Use Case:

Currently the returned values are only displayed, but there is no option to save the result to file locally on computer.

Idea priority Medium
  • Guest
    Aug 30, 2016

    .This function has been delivered. The following lines can be added to the file:

  • Guest
    Jul 11, 2016

    For me this seems to be acceptable.

  • Guest
    Jul 8, 2016

    You are correct in that it the "Enable Save Results" option causes the query to be run differently. We are unable to change that behavior for a number of reasons.

    For the next release, we are considering these two changes:
    1) Allow the ability to enable save results to persist (three options: always, never, and only for this session)
    2) Support a configuration property that allows the results to always be saved, even if the GUI option is set to "never". This would not require the query to be run differently, but will save the results mostly as text data.

    Would that be an acceptable response to this RFE?

  • Guest
    Jul 7, 2016

    I have version Run SQL Scripts and I can save my results using the Options menu and selecting Enable Save Results. I have to do this each time as I believe allowing the save of results causes the query tools to process the queries differently. Formats I have available to me are .txt, .xlsx, .xls, .csv and .ods.

  • Guest
    May 26, 2016

    Creating a new RFE based on Community RFE #88962 in product IBM i.