| View previous topic :: View next topic |
| Author |
Message |
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
 Posted: Tue Apr 22, 2008 9:38 am Post subject: comparing two files using SUPERC. |
 |
|
Hi,
I have two files, one with LRECL of 108 and another with LRECL of 80.
A six digit number starts in 14th column in file A and the same six digit number starts in 5th column in file B. The file A 1000 records and the file B has 1046 records. Now, we need to find out those 46 records to be deleted.
I used SUPERC but no luck....... 
| Code: |
****** *****************
000001 CMPCOLMN 14:6
000002 CMPCOLMO 5:6
****** *****************
|
I got the below shown error: 
| Code: |
THE FOLLOWING PROCESS STATEMENTS (USING COLUMNS 1:72) WERE PROCESSED:
CMPCOLMN 14:6
CMPCOLMO 5:6
ISRS031W AN INVALID START COLUMN VALUE WAS SPECIFIED.
|
Would you please suggest me the correct code either SUPERC way or FILE-AID way?
I would be very grateful if you could give me both.
Thank you very much. 
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Tue Apr 22, 2008 9:47 am Post subject: |
|
|
CMPCOLMN is Starting, ending
not Starting, length
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Tue Apr 22, 2008 10:39 am Post subject: Thank you very much. |
|
|
Hi,
It worked now.
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Tue Apr 22, 2008 10:41 am Post subject: |
|
|
Would anybody please suggest File-Aid way of achieving the same? 
Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
