HELPLIB.HLB  —  RDML72  RDML_ERRORS, SORTSTAT
  SORTED BY found in a boolean or statistical expression

  Explanation:  A SORTED BY clause was found in a record selection
  expression  associated  with  any of the operators ANY, AVERAGE,
  COUNT, MAX, MIN,  TOTAL,  and  UNIQUE.   Although  strictly  not
  incorrect,  the order of records in a stream does not affect the
  value of these operations.

  User Action:  In most  cases,  this  message  results  from  the
  SORTED  BY  clause  being  incorrectly  associated with a nested
  subexpression.  Placing  parentheses  around  the  subexpression
  will  help  RDML  properly  group  the  clause  with the primary
  expression.   Because  of  SQL  syntax  restrictions,  the  side
  effects  of  sort  clauses  on  statistical  expressions in RDML
  cannot be reproduced.
Close Help