Re: Add records and update records

[Jim Essinger <dilbernator@xxxxxxxxx>]

John,

* Trigger as Rob suggested,

*  Keep the file of what was sent to the vendor, then send those not in the
file or changed from the original  - extracting via SQL statement.


HTH

Jim

On Wed, May 30, 2012 at 10:00 AM, John McKee <jmmckee@xxxxxxxxxxxxxx> 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
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.