Page 1 of 1

Exclusive Records - from a PS File

PostPosted: Fri Nov 25, 2011 6:36 pm
by ddash1988
Hi all,

Given 2 PS Files :
1. one contains data of the year 1995 (File1)
2. this one contains data from 1995 - till date (File2)

Requirement :
I need an output PS file (File3) where the data should be from 1996-till date. i.e excluding the data of 1995
in short i need F3 = F2 - F1

Is there any utility I can use? Please provide a breif description on how to work on this.
Thanks in advance.

Re: Exclusive Records - from a PS File

PostPosted: Fri Nov 25, 2011 9:19 pm
by BillyBoyo
You could take file 2 and use sort to OMIT the records for your required date, maybe. You can use OR if you need to exclude on multiple dates.

You could also use sort to "join" the files, maybe, and take those that do not match.

You could write a program (there is a two-file match program as a "sticky" at the top of the Cobol forum).

We'd need a little more information from you, including why it has been posted in the File-AID forum - do you need to do it in File-AID?