I might consider a trigger with a dataque. Perhaps attach a trigger to the morning file, and for any adds or updates pull the trigger and process the data record?

Should that data happen to meet the criteria then create a dataque entry. Then, in whatever regular process is required, fire off a program that forwards whatever resides in the dataque.

That would seem a flexible algorithm that is easy to implement and invites easy changes to meet whatever changing demands the vendor might require in the future.

On 5/30/2012 11:00 AM, John McKee wrote:
We have a process that locates records meeting specified criteria.
Data is written to a file and sent to a vendor. Hours later, same
process is run again, but only new or updated records are sent.
Vendor now wants the second process run multiple times throughout the

I know I can write a program to add new records and update existing
records in the morning file. Can CPYF do this? Is there a "better"
way to accomplish this?

Vendors want results yesterday, so it seems.


John McKee

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].