speermb
New User
Joined: 27 Aug 2008 Posts: 30 Location: USA
|
|
|
|
I am selecting from 1 file need data to go onto 2 different files.
I have:
Code: |
SELECT FROM(INDD) -
TO(OUTDD) -
DISCARD(DUPFILE) -
ON(1,8,CH) -
EQUAL(1) -
USING(SRT1) |
SRTCNTL:
Code: |
SORT FIELDS=(1,8,CH,A)
OMIT CONDITIONN=(1,4,CH,EQ,C'UHDR',OR,1,4,CH,EQ,C'UTRL',OR,1,8,CH,EQ,
C'ML-AC-NO')
INREC IFTHEN=(WHEN=(277,2,CH,EQ,C'BA',AND,
(603,10,CH,NE,C'2010-06-22',AND,
603,10,CH,NE,C'2010-06-29')),
OVERLAY=(11:C'N'),HIT=NEXT),
IFTHEN=(WHEN=(277,2,CH,EQ,C'BA',AND,
(603,10,CH,EQ,C'2010-06-22',OR,
603,10,CH,EQ,C'2010-06-29')),
OVERLAY=(11:C'F'),HIT=NEXT),
IFTHEN=(WHEN=((312,1,CH,NE,C' ',AND,191,1,CH,EQ,C' '),AND,
(11,1,CH,EQ,C'F',OR,11,1,CH,EQ,C'N')),
OVERLAY=(191:C'M')),
IFTHEN=(WHEN=((312,1,CH,NE,C' ',AND,191,1,CH,EQ,C' '),AND,
(11,1,CH,NE,C'F',AND,11,1,CH,NE,C'N')),
OVERLAY=(11:C' ',191:C'M')),
IFTHEN=(WHEN=(NONE),
OVERLAY=(11:C' '))
OUTFIL FNAMES=OUTDD,
IFTHEN=(WHEN=(71,1,CH,NE,C' ',AND,
71,1,CH,NE,C'R',AND,71,1,CH,NE,C'W'),
BUILD=(1:1,8,1X,
772:C'Y',198,1,223,1,226,1,227,1,
542,06,CHANGE=(6,C' ',
C'000000'),NOMATCH=(542,06),
548,06,CHANGE=(6,C' ',
C'000000'),NOMATCH=(548,06),
71,1,67,3,C'B',561,1,C'000000',
455,01,CHANGE=(1,C' ',
C'N'),NOMATCH=(455,01),
568,01,
231,1,
386,1,
84,2,
11,1,
191,1,
114,20,
54,1,
3X,
2X,
66,1,
10X)),
IFTHEN=(WHEN=NONE,
BUILD=(1:1,8,1X,
772:C'Y',198,1,223,1,226,1,227,1,
542,06,CHANGE=(6,C' ',
C'000000'),NOMATCH=(542,06),
548,06,CHANGE=(6,C' ',
C'000000'),NOMATCH=(548,06),
71,1,67,3,C' ',561,1,C'000000',
455,01,CHANGE=(1,C' ',
C'N'),NOMATCH=(455,01),
568,01,
231,1,
386,1,
84,2,
11,1,
191,1,
114,20,
54,1,
3X,
2X,
66,1,
10X))
OUTFIL FNAMES=OUTDD3,
BUILD=(1:1,8,1X,
59X,
C'T',
725,1,CHANGE=(1,C' ',
C'N'),NOMATCH=(725,01),
130X)
|
I am expecting same number of records out OUTDD and OUTDD to be same and have same 8 bytes in position 1-8,
I get:
Quote: |
RECORDS - IN: 14271838, OUT: 14271838
OUTDD : DELETED = 5, REPORT = 0, DATA = 14271833
OUTDD : TOTAL IN = 14271838, TOTAL OUT = 14271833
OUTDD3 : DELETED = 14271835, REPORT = 0, DATA = 3
OUTDD3 : TOTAL IN = 14271838, TOTAL OUT = 3 |
What am I missing? |
|