MVSFORUMS.com

naveen · Beginner Joined: 03 Dec 2002 Posts: 90 Topics: 31

I have two files:

MAINFILE : Which contains say 1000 records
SUBSET: Which contains 700 records out of 1000 records of main file

Now I want to put the remaining 300 hundred records which are there in MAINFILE but not in SUBSET , in a new different file (DIFFILE)

All files are similar FB sequential files of lrecl 133.

How can I do this using SYNCSORT or DFSORT.

Please help.

kolusu · Posted: Thu Jan 09, 2003 10:39 am Post subject:

Naveen,

Does any of the files contain duplicates??

Kolusu

naveen · Beginner Joined: 03 Dec 2002 Posts: 90 Topics: 31

kolusu · Posted: Fri Jan 10, 2003 1:17 am Post subject:

Naveeen,

The following DFSORT/ICETOOL JCL will give you the desired results.If you have syncsort at your shop then change the pgm name to synctool.We concatenate both the files together and using select operator with NODUPS parm we will get the desired results.

naveen · Beginner Joined: 03 Dec 2002 Posts: 90 Topics: 31

In my shop , ICETOOLs are not available. Can this be done using Syncsort or ICEMAN or any other thing. (ICEMAN works on my shop)

Mike Tebb · Posted: Fri Jan 10, 2003 5:19 am Post subject:

As Kolusu mentioned you can substitute ICETOOL with SYNCTOOL if you are in a SYNCSORT shop.
_________________
Cheers - Mike

Frank Yaeger · Posted: Fri Jan 10, 2003 12:12 pm Post subject:

Naveen,

Some clarification of terminology for your future use to avoid confusion:

--
ICETOOL is part of DFSORT. ICEMAN and SORT can be used as the entry point (PGM=ICEMAN) for DFSORT or Syncsort, so saying ICEMAN works does not really say anything about which sort product you have. In your case, since you have Syncsort, ICEMAN is used as the entry for Syncsort.
--

Note that DFSORT's ICETOOL allows CH ON fields up to 1500 bytes so you can use ON(1,133,CH). SYNCTOOL only allows CH ON fields up to 80 bytes.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

naveen · Beginner Joined: 03 Dec 2002 Posts: 90 Topics: 31

Frank , I am now much more confused with the terminology after reading your post . Do you mean to say DFSORT and SYNCSORT are entirely different products.

Can you please explain me , what exactly are following things and relation between them:

1. Syncsort
2. Dfsort
3. ICETOOL
4. ICEMAN
5 .SORT

In my shop , most of the times I use , EXEC PGM = SORT for sorting.

Frank Yaeger · Posted: Sat Jan 11, 2003 10:21 am Post subject:

Naveen,

Yes, DFSORT and Syncsort are entirely different products.

1. Syncsort is the sort product from Syncsort, Inc.

2. DFSORT is the sort product from IBM.

3. ICETOOL is a fully documented multipurpose utility that is part of and shipped with DFSORT. PGM=ICETOOL will execute DFSORT's ICETOOL.

4. ICEMAN is an entry point for DFSORT and Syncsort. PGM=ICEMAN will execute DFSORT or Syncsort, depending on how they are installed at a particular shop.

Actually, "ICE" is the three character prefix assigned to DFSORT by IBM, so all of the DFSORT modules and messages start with "ICE". But Syncsort also ships ICEMAN as an alias for their product. Syncsort's messages start with "WER".

5. SORT is an entry point for DFSORT and Syncsort. PGM=SORT will execute DFSORT or Syncsort, depending on how they are installed at a particular shop.

6. ICEGENER is a "replacement" for IEBGENER that is part of and shipped with DFSORT. PGM=ICEGENER will execute DFSORT's ICEGENER. ICEGENER can also be installed as an automatic replacement for IEBGENER so that PGM=IEBGENER will execute ICEGENER.

I hope this helps clarify things.

Note that you can find a great deal of information about DFSORT at the DFSORT website:

http://www.storage.ibm.com/software/sort/mvs/srtmprd.html

In addition, all of the DFSORT books are online and can be accessed from:

http://www.storage.ibm.com/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

naveen · Beginner Joined: 03 Dec 2002 Posts: 90 Topics: 31

Frank,

Thanks a lot for Information.

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Try this one.

kolusu · Posted: Tue Jan 02, 2007 9:23 am Post subject:

Rajen,

Your solution with sortxsum will NOT work as the poster wanted all the records which are not matched in the main set. XSUM feature is used to get the Duplicate records into a seperate dataset.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

vak255 · Intermediate Joined: 10 Sep 2004 Posts: 384 Topics: 79

Kolusu,

I have a similar requirement but here I want to get the record that is there on both the files. I browsed the manual and tried with equal but getting

kolusu · Posted: Mon Jun 11, 2007 10:30 am Post subject:

vak255,

You are using a PARM EQUAL on SELECT statment but you need to mention a value with EQUAL

Ex: EQUAL(2) this will select the records where ON value occurs 2 times. But then your output will have 4 records if you use that. You just need 1 record. so try this . Your desired output will be in the SORTXSUM DD.

Phantom · Posted: Mon Jun 11, 2007 10:32 am Post subject:

vak255,