APAR status
Closed as returned (APAR cannot be resolved without additional info from IBM or customer.)
Error description
This behavior actually contradicts the normal "ORDER BY" statement, which can also be applied to columns when they do not appear in the SELECT statement (see also https://www.ibm.com/docs/de/informix-servers/14.10?topic=clause- ordering-by-column-by-expression "Informix supports columns and expressions in the ORDER BY clause that do not appear in the select list of the Projection clause.").
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
It can't be reproduced. There is a remote chance that some of these defect fixes might solve this one. (idsdb00108738, idsdb00110072, idsdb00110659 )
APAR Information
APAR number
IT39842
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED RET
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-02-03
Closed date
2023-02-02
Last modified date
2023-02-02
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":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":[{"code":"LOB10","label":"Data and AI"}]}]
Document Information
Modified date:
02 February 2023