ICETOOL question
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 3
- Joined: Mon Jan 21, 2013 5:47 pm
- Contact:
ICETOOL question
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
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
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
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.
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
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
-
- Member
- Posts: 3
- Joined: Mon Jan 21, 2013 5:47 pm
- Contact:
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.
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.
-
- Member
- Posts: 3
- Joined: Mon Jan 21, 2013 5:47 pm
- Contact:
-
- Active Member
- Posts: 732
- Joined: Thu May 24, 2012 4:07 am
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page