Re: Add records and update records

[Booth Martin <booth@xxxxxxxxxxxx>]

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