Need to Compare 2 HOLD Files

[LeonelSanchezJr]

I am using Developer Studio 714.
My task is to create a report which shows me all records which were supposed to be "PAID", but were NOT paid.

I was advised that I would have to create a HOLD1 file of all records with a status of "E" for eligible within a given time period.

Then, create a 2nd HOLD2 file of all records with a status of "P" for paid within the above time period.

Then, create a report based off of those records which exist in HOLD1 (Eligibles), but do NOT exist in HOLD2 (Paid).

I know how to do this in PL/SQL, but not in WebFOCUS CODE.....

Thanks,

Leo ;-)

 

[jimster06]

The thought occurs to me that you should be able to use the JOIN facility for this. Make sure that SET ALL is set appropriately. The E data would be the host and the P data would be the child. Then look for the E records where the P segment is missing.

 

[LeonelSanchezJr]

Thanks, I actually wound up doing this via a match with the OLD-NOT-NEW option and it worked great.
Have a great day!

Thanks,

Leo ;-)