View previous topic :: View next topic
|
Author |
Message |
charu.arora
New User
Joined: 09 Aug 2006 Posts: 2
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
charu.arora
New User
Joined: 09 Aug 2006 Posts: 2
|
|
|
|
No i can use only ICEMAN or Sort Utility |
|
Back to top |
|
|
callkris_cit
New User
Joined: 22 Apr 2006 Posts: 44
|
|
|
|
If it is done by ICETOOL, that will apply to ICEMAN also |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
|