IBM Power Ideas Portal
Hide about this 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.

Add a new idea Subscribe
Status Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Feb 11, 2020

RELATED IDEAS

ACS Run SQL script drop column limitation

See this idea on ideas.ibm.com

When using ACS Run SQL script dropping a column from a table is now not possible without having to use a work around. The suggested work around is not without risks because it also effects other jobs running on the system.


Use Case:

When running the following SQL script:
=====================================

-- category: Data Definition Language (DDL)
-- description: Create or Replace Table

CREATE OR REPLACE TABLE table1 (column1 char(10) NOT NULL, column2 CHAR(10), column3 CHAR(10) );


-- category: Data Manipulation Language (DML)
-- description: Insert into Table

INSERT INTO table1 VALUES('col1_dta1', 'col2_dta1', 'col3_dta1');
INSERT INTO table1 VALUES('col1_dta2', 'col2_dta2', 'col3_dta2');
INSERT INTO table1 VALUES('col1_dta3', 'col2_dta3', 'col3_dta3');

SeleCt * from table1;

-- category: Data Definition Language (DDL)
-- description: Alter Table to Drop Column

ALTER TABLE table1 DROP COLUMN column3 ;

Drop table table1;
==================================

in ACS Run SQL script the issued inquiry message is answered in the background for the drop column statement.
When you run the same statements in STRSQL in 5250 emulation you have the option to answer the issues inquiry message in your 5250 emulation session.

The suggested work around to add the following two commands:
CALL QSYS.QCMDEXC ('CHGJOB INQMSGRPY(*SYSRPYL)', 0000000026.00000);

CL:ADDRPYLE SEQNBR(17) MSGID(CPA32B2) RPY('I');
is not without risks as the system reply list effects every job running on the system using the system reply list.


Idea priority High
  • Guest
    Reply
    |     Apr 20, 2020

    This support is now available in version 1.1.8.4 dated April 2020.

  • Guest
    Reply
    |     Apr 2, 2020

    This is planned for our April 2020 update. An option has been added to Suppress Inquiry Messages under the Options menu.

  • Guest
    Reply
    |     Mar 17, 2020

    The CEAC has reviewed this requirement and recommends that IBM view this as a HIGH priority requirement that is important to address.

    The inability answer to any inquiry message for the job that is running the SQL script means that a valid SQL statement fails because it was auto answered. A cancel reply by the system within run SQL scripts may make some SQL statements appear not to work. This RFE will give the users a chance to use modern tools and avoid switching back to the STRSQL in 5250 emulations.

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

    To find out how CEAC help to shape the future of IBM i, see CEAC @ ibm.biz/BdYSYj and the article "The Five Hottest IBM i RFEs Of The Quarter" at ibm.biz/BdYSZT

    Therese Eaton – CEAC Program Manager, IBM

  • Guest
    Reply
    |     Mar 9, 2020

    May I ask you to add a working example?

  • Guest
    Reply
    |     Mar 7, 2020

    Another option would be an SET OPTION statement to ignore this.

  • Guest
    Reply
    |     Feb 21, 2020

    IBM has received this requirement and is evaluating it. A response will be provided when evaluation is complete.

  • Guest
    Reply
    |     Feb 18, 2020

    Addressing this by adding the ability to specify a different reply list than the system reply list could not only solve this issue, but allow other functions as well. i.e., If you could set up a reply list which included the suggested workaround, you could specify to use the new reply list in the scripting SQL DDL changes.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.