In this blog post, let’s learn about the error message “4153 Statement may not compile due to an order requirement on stream expression.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4153 Statement may not compile due to an order requirement on stream expression.
Reason for the Error
You attempted to compile a stream expression using an ORDER BY on columns that do not define the prefix of the clustering key of the base table or of a secondary index.
Solution
Create a secondary index whose clustering key materializes the order and resubmit
