IBM Support

JR06376: WRONG SORT ORDER ON QUERY RESULTS WHEN USING GUI SORT FUNCTIONALITY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When you are using DB2 GUI tools (for example, DB2 Command
    Center or DB2 Control Center) to query database tables and
    display the query results you may run into the issue of getting
    the wrong sort order with columns having numeric data type.
    If you click on the sort button displayed in the column header
    the results will be displayed in wrong sort order.
    Example: Using german decimal delimiters (Windows Reginal and
    Language Options) sort order should look like following:
    10,22
    100,33
    1.000,44
    10.000,55
    But the GUI displays following ordering after clicking the
    'sort button':
    1.000,44
    10,22
    10.000,55
    100,33
    

Local fix

Problem summary

  • Users Affected: Users who are using graphical tools in the
    manner described in the error description.
    
    Problem Description: If this APAR is not applied, your search
    results (if numeric data is involved) may appear in an incorrect
    sort order in the GUI tools.
    
    Problem Summary: Refer to the error description.
    

Problem conclusion

  • Problem was first fixed in Version 8.1 FixPak 11 (s060120).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR06376

  • Reported component name

    DB2 UDB PE WIND

  • Reported component ID

    5724B5501

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-09-23

  • Closed date

    2006-02-25

  • Last modified date

    2006-02-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB PE WIND

  • Fixed component ID

    5724B5501

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810"}]

Document Information

Modified date:
07 October 2021