Exclusive Records - from a PS File



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Exclusive Records - from a PS File

Postby ddash1988 » Fri Nov 25, 2011 6:36 pm

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.
ddash1988
 
Posts: 4
Joined: Fri Nov 25, 2011 6:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Exclusive Records - from a PS File

Postby BillyBoyo » Fri Nov 25, 2011 9:19 pm

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?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post