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 (https://ideas.ibm.com).


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 (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Not under consideration
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Dec 12, 2018

ACS Run SQL Scripts add server connection language for scripts run through ACS RSS

Please provide script language feature to allow for connecting and disconnecting from a server named.


Use Case:

There are times when I write scripts that cause me to constantly perform a reconnect or connect to multiple servers.

I know I can press Ctrl+F11 to reconnect then run the script but it would be nice after many test cycles to just press CTRL+SHIFT+A (run all).


Idea priority Medium
  • Guest
    Reply
    |
    Jan 10, 2019

    Unfortunately, you assume the command line is a flexible option but it is not. I don't always want to have to write script for the command line option for the different scripts I might write. Plus, I don't always want to automate the running of my scripts. I would like to run the SQL script on test server, validate results then run on the production server. My scripts often produce results which I would like to examine before running on production.

    Thinking this over more then main reason using the connection dialog box is burdensome is we use IASPs and the requirement to always select the IASP at connection time. I know the connection dialog defaults to the last selected for that server but there has to be a selection made first before it remembers. For those that have several IASPs this can become even more tedious.

    Please reconsider.

  • Guest
    Reply
    |
    Jan 9, 2019

    The RSS plugin from the command line provides the flexibility to quickly switch between servers or to do multiple systems from a script/bat file as previously mentioned. With that in mind, the decision at this time is to not provide the additional requested support.

  • Guest
    Reply
    |
    Jan 8, 2019

    While I admit I had not considered the command line as an option I don't think its always appropriate for some scripts. I will consider this option.

    The thought I had when I wrote this RFE is that I would like some way to open a RSS session examine the script, run it on test until its working fine and then quickly connect to the production server to run ONCE there. I don't always want to run on both/multiple servers from the same script in a batch.

  • Guest
    Reply
    |
    Jan 7, 2019

    The original request sounds like you are asking for a particular RSS script to be run against multiple partitions. If that is what is needed, there is already support for running an RSS script from the command line using the RSS plugin. See GettingStarted section 9.1.31 ftp://ftp.software.ibm.com/as400/products/clientaccess/solutions/GettingStarted_en.html#9.1.31. Using the RSS plugin, you could write a shell script or bat file to invoke your RSS script multiple times to your various partitions. Is that sufficient for what you need?

  • Guest
    Reply
    |
    Dec 13, 2018

    If this request is implemented, it would be nice if it could accommodate variable server/partition values. A script could be coded to work on a development server/partition then be promoted to test then production based on environment variables rather than changing the script at each level.