ICETOOL question

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
Rich Lewis
Member
Posts: 3
Joined: Mon Jan 21, 2013 5:47 pm
Contact:

ICETOOL question

Post by Rich Lewis » Mon Jan 21, 2013 5:56 pm

Hi all.

Can anyone please help with a DFSORT/ICETOOL question:-

- There are 2 files FILE1 and FILE2.
- If any records on FILE2 also exist on FILE1 then I want to remove those records from FILE2 and copy the remaining FILE2 records out.
- FILE1 does not need to be altered or copied out
- Both files are 50 byes long, are sorted in ASC, are FB, and the key is the entire 50 bytes.

Thanks in advance,
Richard

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Jan 21, 2013 7:28 pm

In SORT application, usually it's not advised to use the output, same as input file. It may damage your file. Do you really want the records to be deleted, if you copy in third file, won't that suffice?

And suggest you show some example of input records from both the file and the expected output from them.
Last edited by Anuj Dhawan on Mon Jan 28, 2013 4:10 pm, edited 1 time in total.
Regards,
Anuj

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Mon Jan 21, 2013 7:30 pm

And I've moved your topic from "General Discussion" to "JCL" part of the Forum.
Regards,
Anuj

Rich Lewis
Member
Posts: 3
Joined: Mon Jan 21, 2013 5:47 pm
Contact:

Post by Rich Lewis » Mon Jan 21, 2013 8:54 pm

Thanks for your reply.

So let me re-phrase it:-

- there are 2 files FILE1 and FILE2.
- FILE2 is the master file - those that exist on FILE2 which DON'T exist on FILE1 need to be written out to FILE3
- Both files are 50 byes long, are sorted in ASC, are FB, and the key is the entire 50 bytes.

FILE1 records
ABC 012
ABC 234
ABC 345
ABC 789
ABC 890

FILE2 records
ABC 123
ABC 234
ABC 345
ABC 456
ABC 789

Resultant Output file FILE3
ABC 123
ABC 456

Can anyone give some example code?

Thanks.

MrSpock
Active Member
Posts: 273
Joined: Wed Jun 27, 2007 5:37 pm

Post by MrSpock » Tue Jan 22, 2013 2:24 am

Sounds like a normal JOINKEYS (JOIN UNPAIRED) operation to me.

Rich Lewis
Member
Posts: 3
Joined: Mon Jan 21, 2013 5:47 pm
Contact:

Post by Rich Lewis » Tue Jan 22, 2013 2:00 pm

Thanks MrSpock, but do you have any example JCL you could paste into here?

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Tue Jan 22, 2013 3:15 pm

Google with JOINKEYS UNPAIRED

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Jan 22, 2013 10:00 pm

Or simply Search in the forum :wink:
Have a good one

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Wed Jan 23, 2013 2:10 am

The JCL is in the sort manual - you will have to think about the sort control cards - which are not JCL.

Why isn't this in the DFSORT section?!
Regards
Nic

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others