IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to take rejected or dropped records into a file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sudhamani

New User


Joined: 08 Nov 2007
Posts: 19
Location: india

PostPosted: Mon May 26, 2008 6:26 pm
Reply with quote

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
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon May 26, 2008 9:17 pm
Reply with quote

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.
Back to top
View user's profile Send private message
sudhamani

New User


Joined: 08 Nov 2007
Posts: 19
Location: india

PostPosted: Mon May 26, 2008 10:11 pm
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon May 26, 2008 10:36 pm
Reply with quote

Hello,

Quote:
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.
Please provide the requested info.
Back to top
View user's profile Send private message
sudhamani

New User


Joined: 08 Nov 2007
Posts: 19
Location: india

PostPosted: Tue May 27, 2008 5:05 pm
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 0
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
Search our Forums:

Back to Top