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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am


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