IBM Support

PK49743: SORT OPERATION SHOWS ERROR WITH DESCRIPTION FIELD.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as user error.

Error description

  • Creating a query containing a multi-line text field and then att
    empting to sort on the multi-line field generates a SQL error in
     SQL Server, Oracle, and DB2.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Sorting on multi-line text fields is not possible due to the
    underlying databases vendor architecture.  The error message
    generated includes the SQL error returned directly from the
    database vendor to provide the end user with enough
    information to understand the problem as well as the
    detailed information as to what field(s) caused the current
    error. With this information it is possible to correct this
    problem by removing the multi-line field sort.
    

APAR Information

  • APAR number

    PK49743

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    605

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-07-25

  • Closed date

    2008-04-04

  • Last modified date

    2008-04-04

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 April 2008