Skip to Content
author's profile photo
Former Member

Internal Table Sorts following an Upgrade


We are in the middle of upgrading our 4.6c system to ECC 5.0, and as part of this have had to do the codepage conversion and upgrade in a test environment. Mostly this seems fine, however, our application support people are running some tests, and are getting different results to Live. This looks to be down to a function called SORT, which is transferring data to an internal table. However, having compared the data at iSeries level in both ASCII and EBCDIC, I can see that the tables are arranged differently i.e. Numbers first, then alphanumeric second.

Does anyone know if it is possible to change the order that SAP reads this data, so that it continues to read it as if it was arranged as per EBCDIC?

Thanks in advance,


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 10:03 PM

    Hi Dan,

    I know, that you might have been the first ECC 5.0 customer - but I would STRONGLY recommend, that you upgrade the next systems to ECC 6.0 now - that is an environment with a lot more support ...

    PLEASE: Rethink your decision on ECC 5.0 to 6.0 !!!

    Now to your topic:

    Digits are "bigger" in EBCDIC and lower in ASCII than characters - unfortunately this is always the case in SORT - this is one of the changes of the ASCII CPC - that you cannot change - => if your programs rely on that, you have to change them ;-(

    If your users are used to the order, you should "retrain" them ...


    Volker Gueldenpfennig, - -

    Add comment
    10|10000 characters needed characters exceeded