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