Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to take rejected or dropped records into a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: how to take rejected or dropped records into a file
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 Moderator


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

PostPosted: Mon May 26, 2008 9:17 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Mon May 26, 2008 10:36 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us