below is a sample of the data I've been working with
****** ***************************** Top of Data ******************************
=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
000001 DTST2520 DTST2520 0003926 01/01/12-01:30 01/01/12-01:30 0:09 SIN
000002 DTST2520 DTST2520 0005114 01/08/12-01:30 01/08/12-01:30 0:09 SIN
000003 DTST2002 DTST2002 0004119 01/02/12-05:15 01/02/12-05:15 0:19 SIN
000004 DTST2003 DTST2003 0004148 01/02/12-08:00 01/02/12-08:07 7:29 SIN
000005 DTST2001 DTST2001 0004147 01/02/12-08:00 01/02/12-08:08 8:25 SIN
000006 DTST2002 DTST2002 0005305 01/09/12-05:15 01/09/12-05:15 0:19 SIN
000007 DTST2003 DTST2003 0005337 01/09/12-08:00 01/09/12-08:00 0:05 SIN
=COLS> ----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
000001 DTST2520 DTST2520 0003926 01/01/12-01:30 01/01/12-01:30 0:09 SIN
000002 DTST2520 DTST2520 0005114 01/08/12-01:30 01/08/12-01:30 0:09 SIN
000003 DTST2002 DTST2002 0004119 01/02/12-05:15 01/02/12-05:15 0:19 SIN
000004 DTST2003 DTST2003 0004148 01/02/12-08:00 01/02/12-08:07 7:29 SIN
000005 DTST2001 DTST2001 0004147 01/02/12-08:00 01/02/12-08:08 8:25 SIN
000006 DTST2002 DTST2002 0005305 01/09/12-05:15 01/09/12-05:15 0:19 SIN
000007 DTST2003 DTST2003 0005337 01/09/12-08:00 01/09/12-08:00 0:05 SIN
my code below
//SYSIN DD *
SORT FIELDS=(12,8,CH,A,29,13,CH,D)
SUM FIELDS=NONE
OUTFIL OUTREC=(2:12,8,
12:29,30,
50:104,4,
55:C' '),
HEADER1=(3:'JOBNAME',
17:'START',
33:'END',
50:'SYSID',
59:'PAGE:',
68:&PAGE,/,
17:'TIME',
32:'TIME',//)
/*
SORT FIELDS=(12,8,CH,A,29,13,CH,D)
SUM FIELDS=NONE
OUTFIL OUTREC=(2:12,8,
12:29,30,
50:104,4,
55:C' '),
HEADER1=(3:'JOBNAME',
17:'START',
33:'END',
50:'SYSID',
59:'PAGE:',
68:&PAGE,/,
17:'TIME',
32:'TIME',//)
/*
is working but not removing the duplicates, from what I understand from reading the Programmers Guide, the SUM FIELDS is what's needed to remove dups from the SORT FIELDS statement, but my output still contains duplicates, can anyone eyeball my code and tell me what I'm missing?
Thanks
output data follows
********************************* TOP OF DATA **********************************
JOBNAME START END SYSID PAGE:
TIME TIME
DSUT1000 01/10/12-00:01 01/10/12-00:01 TST1
DSUT1000 01/09/12-00:01 01/09/12-00:01 TST1
DSUT1000 01/08/12-00:01 01/08/12-00:01 TST1
DSUT1000 01/07/12-00:01 01/07/12-00:01 TST1
DSUT1000 01/06/12-00:01 01/06/12-00:01 TST1
DSUT1000 01/05/12-00:01 01/05/12-00:01 TST1
DSUT1000 01/04/12-00:01 01/04/12-00:01 TST1
DSUT1000 01/03/12-00:01 01/03/12-00:01 TST1
DSUT1000 01/02/12-00:01 01/02/12-00:01 TST1
DSUT1000 01/01/12-00:01 01/01/12-00:01 TST1
DSUT1001 01/10/12-00:01 01/10/12-00:01 TST1
DSUT1001 01/09/12-00:01 01/09/12-00:01 TST1
DSUT1001 01/08/12-00:01 01/08/12-00:01 TST1
DSUT1001 01/07/12-00:01 01/07/12-00:01 TST1
DSUT1001 01/06/12-00:01 01/06/12-00:01 TST1
DSUT1001 01/05/12-00:01 01/05/12-00:01 TST1
DSUT1001 01/04/12-00:01 01/04/12-00:01 TST1
DSUT1001 01/03/12-00:01 01/03/12-00:01 TST1
DSUT1001 01/02/12-00:01 01/02/12-00:01 TST1
JOBNAME START END SYSID PAGE:
TIME TIME
DSUT1000 01/10/12-00:01 01/10/12-00:01 TST1
DSUT1000 01/09/12-00:01 01/09/12-00:01 TST1
DSUT1000 01/08/12-00:01 01/08/12-00:01 TST1
DSUT1000 01/07/12-00:01 01/07/12-00:01 TST1
DSUT1000 01/06/12-00:01 01/06/12-00:01 TST1
DSUT1000 01/05/12-00:01 01/05/12-00:01 TST1
DSUT1000 01/04/12-00:01 01/04/12-00:01 TST1
DSUT1000 01/03/12-00:01 01/03/12-00:01 TST1
DSUT1000 01/02/12-00:01 01/02/12-00:01 TST1
DSUT1000 01/01/12-00:01 01/01/12-00:01 TST1
DSUT1001 01/10/12-00:01 01/10/12-00:01 TST1
DSUT1001 01/09/12-00:01 01/09/12-00:01 TST1
DSUT1001 01/08/12-00:01 01/08/12-00:01 TST1
DSUT1001 01/07/12-00:01 01/07/12-00:01 TST1
DSUT1001 01/06/12-00:01 01/06/12-00:01 TST1
DSUT1001 01/05/12-00:01 01/05/12-00:01 TST1
DSUT1001 01/04/12-00:01 01/04/12-00:01 TST1
DSUT1001 01/03/12-00:01 01/03/12-00:01 TST1
DSUT1001 01/02/12-00:01 01/02/12-00:01 TST1