how to take rejected or dropped records into a file

sudhamani · New User Joined: 08 Nov 2007 Posts: 19 Location: india

Hi,

Iam using icetool control card for matching records and taking into a file .but it is dropping some of the records into output file.is there any option to take rejected recoreds into a file when using the SPLICE operator.

Thanks

Frank Yaeger · Posted: Mon May 26, 2008 9:17 pm Post subject:

Do you really think that's enough information for somebody to help you? We don't know what your input records look like, what you want for output, what JCL you're using or what control statements you're using, so how could you possibly expect us to answer your question? We don't even know if you have one input file or two input files.

Show an example of the records in your input file(s) and what you expect for output. If you can have duplicates within a file, show that in your example. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file(s). Give the starting position, length and format of each relevant field.

sudhamani · New User Joined: 08 Nov 2007 Posts: 19 Location: india

Hi,

i have two input files and taking matched records to one file and non matched to another .but some of the records are dropping in the output file because iam sorting the file on SSN and merging on SSN.but there are same ssn's(duplicate) for different userid's in the file and they are getting dropped.

this is the code iam using

//TOOLIN DD *
COPY FROM(IN1) TO(O1) USING(CTL1)
COPY FROM(IN2) TO(O1) USING(CTL2)
SELECT FROM(IN1) TO(OUT1) ON(27,9,CH) ALLDUPS
SPLICE FROM(O1) TO(MATCH) USING(CTL3) -
ON(27,9,CH) WITH(37,1) WITH(41,7) WITH(51,9) KEEPNODUPS
//CTL1CNTL DD *
SORT FIELDS=(27,9,CH,A)
INREC BUILD=(1:1,8,9:9,17,X,27:27,9,36:C'11',22X,
60:60,9,3X,72:72,8,80:X)
/*
//CTL2CNTL DD *
SORT FIELDS=(5,9,CH,A)
INREC BUILD=(27:5,9,36:C'22',3X,41:106,7,3X,51:124,9,21X)
/*
//CTL3CNTL DD *
OUTFIL FNAMES=MATCH,INCLUDE=(36,2,CH,EQ,C'12'),OVERLAY=(36:2X)
OUTFIL FNAMES=NOTM,INCLUDE=(36,2,CH,EQ,C'11'),OVERLAY=(36:2X)

how can i take the SSN'S that are same for different userid's also to output files both match and nonmatch criteria .

Thank You.

dick scherrer · Posted: Mon May 26, 2008 10:36 pm Post subject:

Hello,

sudhamani · New User Joined: 08 Nov 2007 Posts: 19 Location: india

Hi,

here are the input s and the expected out puts:

two input files and out put files

IN1:

Cols(1-8) 09-25 (27-35) cols(60-68) cols(72-79)
Userid name SSN account racf

ANNNSSQW xxxxxxxxxx 500037501 141182321 weererds
DCHNSAER xxxxxxxxxx 500037501 232784371 ewmckmaa
ASSNHDAS xxxxxxxxxx 679003221 939849841 djskudwa
TYWEQIER xxxxxxxxxx 679003221 372873281 shduydwa
TYWEQIER xxxxxxxxxx 679003221 387434831 sdhyuyqq
DDYIJSJTY xxxxxxxxxx 300000000 678463464 jdwueiej

IN2:

(5-13-ssn)key cols(106-112) cols(124-132 )

ABF0 500037501 xxxxxxxxxxxxxxxxx 1237890 xxxxxx sdhsjkdue
PAF0 679003221 xxxxxxxxxxxxxxxxx 6870893 xxxxxx njhewyuee
FGD0 345713892 xxxxxxxxxxxxxxxx 68790-90 xxxxxx mcxewtqta

merging by key SSN:

Outputs:

1.Matched records:

USERID(1-8) name(9-26) ssn(27-35) Phone(41-48) loc(51-59) account(60-69) racf (72-79)

ANNNSSQW xxxxxxxxxx 500037501 1237890 sdhsjkdue 141182321 weererds
DCHNSAER xxxxxxxxxx 500037501 1237890 sdhsjkdue 232784371 ewmckma
ASSNHDAS xxxxxxxxxx 679003221 6870893 njhewyuee 939849841 djskudwa
TYWEQIER xxxxxxxxxx 679003221 6870893 njhewyuee 372873281 shduydwa
TYWEQIER xxxxxxxxxx 679003221 6870893 njhewyuee 387434831 sdhyuyqq

2.Non matched records:

USERID(1-8) name(9-26) ssn(27-35) phone(41-48) loc(51-59) account(60-69) racf (72-79)

DDYIJSJTY xxxxxxxxxx 300000000 ----------- ------------- 678463464 jdwueieji