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.

112 VOTE
Status Delivered
Workspace IBM i
Categories Languages - RPG
Created by Guest
Created on Aug 9, 2016

Provide an %UPPER and %LOWER bif

It would be helpful to have an easier and more robust way to change the case of characters from upper to lower or lower to upper. The current method is to use the %XLATE function, but the usual way that this is coded (just using the main 26 letters of the alphabet) does not address variables in other CCSIDs or characters in different languages (like vowels with a tilde).


Use Case:

Instead of this:
D lo C const('abcdefghijklmnopqrstuvwxyz')
D up C const('ABCDEFGHIJKLMNOPQRSTUVWXYZ')

uppervalue = %xlate(lo:up:lowervalue)
lowervalue = %xlate(up:lo:uppervalue)

would like to do this:
uppervalue = %upper(lowervalue)
lowervalue = %lower(uppervalue)


Idea priority Low
  • Guest
    Reply
    |
    Apr 16, 2021

    IBM believes that the request described has been solved and is available with PTFs for 7.3 and 7.4.

    7.3
    ILE RPG runtime: SI76098 - you need this PTF on any 7.3 system where you run a program with %LOWER or %UPPER
    ILE RPG compiler: SI76100

    7.4
    ILE RPG runtime: SI76099 - you need this PTF on any 7.4 system where you run a program with %LOWER or %UPPER
    ILE RPG compiler: SI76101
    ILE RPG compiler for TGTRLS(V7R3M): SI76109

    For more information about the new %LOWER and %UPPER built-in functions, see https://www.ibm.com/support/pages/node/6442065

  • Guest
    Reply
    |
    Apr 13, 2021

    IBM agrees with the request and a solution will be available in the future.

    For more information about %LOWER and %UPPER, see https://www.ibm.com/support/pages/node/6442065.

  • Guest
    Reply
    |
    Dec 16, 2020

    Indeed nice to have.
    Escaping to SQL or C just to do a character conversion is a pity.
    Remember that such function will cover different CCSIDs seamlessly (like unicode etc.).

  • Guest
    Reply
    |
    Dec 9, 2020

    I've been requested to add the following to this RFE:
    Include OPTION(*UPPER | *LOWER) to the OPTION parameter keyword for prototypes and procedures in RPG IV.
    Please see my new RFE on just that specific enhancement which should be introduced concurrently with %UPPER/%LOWER

    http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=147289

  • Guest
    Reply
    |
    Dec 4, 2020

    In the interim, you may find Paul Tuohy's SQLSCALAR utility useful, if not just for LOWER and UPPER bifs, but others as well:
    https://www.itjungle.com/2016/11/15/fhg111516-story01/

  • Guest
    Reply
    |
    Aug 29, 2020

    You can use the QlgConvertCase API (wrap it in a procedure) to have full codepage support.

    BTW, just add %CamelCase as well please.

  • Guest
    Reply
    |
    Aug 28, 2020

    Heck, even CL now has %UPPER and %LOWER bifs. Surely we can keep up with the functionality that CL has, can't we?

  • Guest
    Reply
    |
    Aug 24, 2020

    The CEAC has reviewed this requirement and recommends that IBM view this as a HIGH priority requirement that is important to address.
    Keep the RPG language up to date with other languages and to keep away the argument of moving away from RPG.

    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
    |
    Jun 9, 2020

    For developers waiting a CCSID-safe interface to make upper or lower case work today, and who don't want to use the very reliable QlgConvertCase API, you can use SQL to do this:

    EXEC SQL VALUES upper( :Company ) INTO :Company;

  • Guest
    Reply
    |
    Apr 27, 2020

    This request is still a candidate to be an enhancement for the RPG compiler.

  • Guest
    Reply
    |
    Aug 18, 2017

    One of the many BIF that are in other languages but not in RPG. I would add %proper() to it.

    name = 'bARBARA mORRIS';
    dsply name; // 'bARBARA mORRIS'

    name = %proper(name);
    dsply name; // 'Barbara Morris'

    I would also add
    a = %isnull(name); // a='0' because name <> null
    b = %isalpha(name); // b='1' because it is all alphabets
    c = %isnumeric(name); // c='0' because it is not numeric

  • Guest
    Reply
    |
    Aug 15, 2017

    The CAAC has reviewed this requirement and recommends that IBM view this as a “nice to have” low priority feature. This will be particularly useful, as the author mentioned, when characters have accents on them.

    Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key 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.

    For more information about CAAC, see www.common.org/caac

    For more details about CAAC's role with RFEs, see http://www.ibmsystemsmag.com/Blogs/i-Can/May-2017/COMMON-Americas-Advisory-Council-%28CAAC%29-and-RFEs/

    Dawn May - CAAC Program Manager

  • Guest
    Reply
    |
    Jul 31, 2017

    Long overdue. I would prefer adding %PROPER to it i.e. "abcd EFGH" be translated to "Abcd Efgh".

  • Guest
    Reply
    |
    May 3, 2017

    It is not only for ease of use, it is also to have more standarization.

    It is no problem for the programmers to code "uppervalue = %xlate(lo:up:lowervalue)", and add or copy from a copy-member 2 constants. or have it in a external program-subprocedure. But this approach make it not standard. One programmer is using %XLATE, another programmer is using an external program, another one is using an external procedure, another one is using an internal procedure etc.

    If IBM add the %UPPER and %LOWER bif so many individual user routine will be eliminated and the code will be more satndard.

    A similar request for standarization I wrote here:
    https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=104154

  • Guest
    Reply
    |
    Mar 30, 2017

    IBM will use this request as input to planning but no commitment is made or implied. This request will be updated in the future if IBM implements it. IBM will use votes and comments from others in the community to help prioritize this request.

  • Guest
    Reply
    |
    Oct 28, 2016

    IBM has received the requirement and is evaluating it. IBM will provide a response after evaluation is complete.

  • Guest
    Reply
    |
    Aug 10, 2016

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

0 MERGED

Add Upper/Lower case built-ins to RPG IV

Merged
Add %UPPER and %LOWER to RPG IV as built-in function. These functions would (obviously) convert the parameter value to upper or lower case respectively . Use Case: Input from myriad sources into RPG requires the ability to verify that data using c...
almost 6 years ago in IBM i / Languages - RPG 4 Delivered
0 MERGED

RPGIV BIFs for uppercase/lowercase conversion

Merged
Add a BIF to RPGIV to convert the alphanumeric argument to lowercase (e.g. %tolower), and a BIF to convert the alphanumeric argument to uppercase (e.g. %toupper). Every PL i know of has these fundamental functions available "built-in". Use Case: I...
over 3 years ago in IBM i / Languages - RPG 5 Delivered