SELECT FROM(FAILURES) TO(CHECKOUT) ON(28,8,CH) ON(1,5,CH) -
   HIGHER(3)

Sorts the FAILURES data set to the CHECKOUT data set, selecting only the records from FAILURES with characters in positions 28-35 and characters in positions 1-5 that occur more than three times (that is only records with four or more duplicate ON field values).

The CHECKOUT data set might look as follows (several records are shown for illustrative purposes):

03/12/04   08:36:59        A3275647
03/12/04   09:27:32        A3275647
03/12/04   09:03:18        A3275647
03/12/04   08:56:13        A3275647
03/06/04   15:12:01        C3275647
03/06/04   14:57:00        C3275647
03/06/04   15:43:19        C3275647
03/06/04   16:06:39        C3275647
03/06/04   15:22:08        C3275647
.          .               .
.          .               .
.          .               .