VMS Help  —  RDML72  RDML_ERRORS, BETWEENORD
  BETWEEN operands must be in order in SQL

  Explanation:  RDML interprets the BETWEEN  operator  differently
  from  SQL.   In  RDML,  "A  BETWEEN  B OR C" is equivalent to "A
  BETWEEN C OR B".  Although the converter could have generated  a
  functionally   equivalent  disjunction,  this  would  have  been
  sloppy.  If the converter can evaluate the expressions, it  does
  and  places  the  expressions  in the correct order.  If not, it
  produces a warning.  The diagnostic file can be used  to  easily
  locate and modify this code.

  User Action:  Make sure that the second and third operands of  a
  BETWEEN    expression    are   always   properly   ordered;   or
  alternatively, OR the BETWEEN clause generated with another with
  the second and third operands in reverse order.
Close Help