Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Unmatching records from two inputs to an outpu

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Tue Dec 27, 2005 1:21 pm    Post subject: Icetool Splice
Reply with quote

Can i get the unmatching records from two inputs to an output file by splice or a normal sort.
Input1 :
111 abcd
111 cdef
222 acfg

Input2 :
111 mnop
333 acfg

My output should be like
111 abcd
111 cdef
i;e the output file shud contain only those record from the input file which has got a matching key(here first 4 chars) in the second file. Please let me know whether this can be done by a normal sort or if there is a way of using the splice function please let me know that also.

Thanks,
Nithin.
Back to top
View user's profile Send private message

pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Tue Dec 27, 2005 1:41 pm    Post subject: unmatched records
Reply with quote

Here I also need to get the unmatching records in another file. Like,
Input1 :
111 abcd
111 cdef
222 acfg

Input2 :
111 mnop
333 acfg

unmatch records output file:
222 acfg
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Tue Dec 27, 2005 1:55 pm    Post subject: Re: Unmatching records from two inputs to an outpu
Reply with quote

Refer to the link below...

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05

Regards,

Priyesh.
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Tue Dec 27, 2005 2:15 pm    Post subject: Re: Unmatching records from two inputs to an outpu
Reply with quote

Priyesh,
It worked, but what does KEEPNODUPS option makes. I was trying without that, like:

SPLICE FROM(T2) TO(OUT) ON(1,13,CH) WITHALL -
WITH(81,3) USING(CTL4)
But in this cases only the matching records were spliced and coming in the output. None of the unmatched records from either of files 1 or 2 was not coming in the output.
Anyways thanks for ur help.

Nithin.

priyesh.agrawal wrote:
Refer to the link below...

http://www-03.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst02.html#t05

Regards,

Priyesh.
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: Tue Dec 27, 2005 8:43 pm    Post subject:
Reply with quote

Quote:
what does KEEPNODUPS option makes


If you specify KEEPNODUPS, the unmatched records are kept. If you don't specify KEEPNODUPS, the unmatched records are deleted.

For complete details on the SPLICE operator of DFSORT's ICETOOL and all of its parameters, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/6.13?DT=20050222160456
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
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us