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 Sort & compare two files with removing duplicates

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

New User


Joined: 09 Aug 2006
Posts: 2

PostPosted: Wed Nov 08, 2006 12:53 pm    Post subject: How to Sort & compare two files with removing duplicates
Reply with quote

Hi,

I am having 2 files. One is having 100 records & 2nd 20 records.now i want to detete the records present in 1 st file which are same in 2nd file with the help of sort utility.I can not use ICETOOL.


The other problem is that both have primary key as Account No & data is same for all records in both of the file for acc no like 1111111111.


Now i have two things on which i can put key .That is Call Date & Call time but these fileds have different foramt in both of the files & even diff positions in the copybook.

like

5 WS-FK-ACCOUNT-NUMBER PIC S9(0010) COMP-3
VALUE 0.
05 WS-FK-SUB-ACCOUNT-NUMBER PIC S9(0003) COMP-3
05 WS-FK-ACCOUNT-SERVICE-NUMBER PIC S9(0004) COMP-3
05 WS-DATE-BILLED PIC S9(08).
05 WS-PHYSICAL-PARTITION-NUMBER PIC S9(0004) COMP.
05 WS-CALL-TYPE PIC X(0002).
05 WS-DATE-START PIC S9(08).
05 WS-TIME-START PIC S9(06).
05 WS-OVERLAP-NUMBER PIC S9(0004) COMP.
05 WS-PHONE-NUMBER-BILLED PIC X(0010).
05 WS-PHONE-NUMBER-OTHER-PARTY PIC X(0018).
05 WS-LOCATION PIC X(0011).
05 WS-PHONE-NUMBER-DIALLED PIC X(0018).
05 WS-BILL-CYCLE PIC S9(0002) COMP-3
05 WS-CALL-ASSIST-TYPE PIC X(0001).


&


10 WS-RRM-ACCT-NBR PIC S9(10)V USAGE COMP-3.
10 WS-RRM-SUB-ACCT-NBR PIC S9(3)V USAGE COMP-3.
10 WS-RRM-ACCT-SRVC-NBR PIC S9(4) USAGE COMP.
10 WS-RRM-CALL-TYP PIC X(2).
10 WS-RRM-DTE-STRT PIC X(10).
10 WS-RRM-TIME-STRT PIC X(8).
10 WS-RRM-PH-NBR-BILL PIC X(10).
10 WS-RRM-OVER-LAP-NBR PIC S9(4) USAGE COMP.
10 WS-RRM-BILL-CYCL PIC S9(2)V USAGE COMP-3.
10 WS-RRM-CALL-ASIS-TYP PIC X(1).
10 WS-RRM-CALL-ASIS-TYP-NL PIC X(1).
10 WS-RRM-DIST-CLSS PIC X(3).
10 WS-RRM-DIST-CLSS-NL PIC X(1).
10 WS-RRM-DURN PIC S9(6)V USAGE COMP-3.
10 WS-RRM-ADJ-NBR PIC S9(10)V USAGE COMP-3.



Please help me .Its urgent
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: Wed Nov 08, 2006 9:18 pm    Post subject:
Reply with quote

Quote:
I can not use ICETOOL.


Why not? Are you using DFSORT? If so, then DFSORT's ICETOOL is available to you.
Back to top
View user's profile Send private message
charu.arora

New User


Joined: 09 Aug 2006
Posts: 2

PostPosted: Thu Nov 09, 2006 12:36 pm    Post subject: No i can use only ICEMAN or Sort Utility
Reply with quote

No i can use only ICEMAN or Sort Utility
Back to top
View user's profile Send private message
callkris_cit

New User


Joined: 22 Apr 2006
Posts: 44

PostPosted: Mon Nov 13, 2006 2:54 pm    Post subject: Re: How to Sort & compare two files with removing duplic
Reply with quote

If it is done by ICETOOL, that will apply to ICEMAN also
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 Nov 13, 2006 11:34 pm    Post subject:
Reply with quote

Quote:
No i can use only ICEMAN or Sort Utility


PGM=ICEMAN or PGM=SORT invokes the sort product at your site. That can be DFSORT, Syncsort or CA-SORT. If you're using DFSORT, then you can use DFSORT's ICETOOL (it comes free with DFSORT). If you're not using DFSORT, or you can't use DFSORT's ICETOOL for some reason, then I can't help you.
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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts member list compare jzhardy TSO/ISPF 6 Fri May 12, 2017 3:18 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm


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