Results 1 to 4 of 4

Thread: Using the built in function %UPPER in a CL

  1. #1
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229

    Question Using the built in function %UPPER in a CL

    I'm coding a CLP where a value comes to me in mixed upper/lower case.
    I'm trying to use the %UPPER built in function to get unmixed upper case.

    Per the IBM documentation:
    "The %UPPER built-in function returns a character string that is the same length as the argument specified with each lowercase letter replaced by the corresponding uppercase letter.

    The %UPPER built-in function can be used anywhere that CL supports a character expression.
    %UPPER can be used alone or as part of a more complex character expression.

    For example, %UPPER can be used to convert character CL variables to have only upper case characters
    before comparing them in the COND parameter of an IF or WHEN command.

    %UPPER can also be used to set the value of a CL command parameter,
    if the associated command object defines the parameter with EXPR(*YES) and TYPE of *CHAR, *NAME, *SNAME, *CNAME, *PNAME, *GENERIC, *DATE, *TIME, or *X."


    They cite an example of:
    SNDPGMMSG (%UPPER(&STR))

    When I try to use %UPPER, even the IBM example, I get error CPD0056
    "Message . . . . : Built-in function %UPPPER not valid.
    Cause . . . . . : Built-in function name not found or built-in function name is not valid for the type of program in which it is specified.
    Recovery . . . : Change the name specified for the built-in function or omit the percent sign in front of the name."


    Does %UPPER work in CLP?
    Would someone please post an example of %UPPER in a CLP?

    Thanks
    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  2. #2
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    There are only a few built-in functions available at V6R1:

    https://www.ibm.com/support/knowledg...uiltinfunc.htm

    They have been expanded in later releases:

    https://www.ibm.com/support/knowledg...e/pdftable.htm

    We're going to try and move to V7R2 within the next few months...can't wait
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

  3. #3
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229
    Thanks for the reply.
    I checked, and we are on V7R1, and %UPPER isn't available.
    RATS!

    Thanks,
    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  4. #4
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    For future reference...a link to V7R2 enhancements:

    https://www.ibm.com/support/knowledg...m6whatsnew.htm
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.