Re: Add records and update records

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
day.

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.



Thanks

John McKee