Re: Record Deletion on a Remote System

[Alan Campin <alan0307d@xxxxxxxxx>]

You could use Scott's JDBC API. Other way to do IBM but that means buying
software from IBM.

On Tue, Jul 5, 2011 at 7:59 AM, <Blake.Moorcroft@xxxxxxxxxx> wrote:

> Hello all...
>
> I'm got a situation where as part of a transaction record purge, we need
> to remove associated records from a set of files that are stored on a
> remote system.  This would be done by an automated process.  The basic
> scenario is as follows:
>
> a) Collect transaction record control IDs
> b) Remove transaction records from files on primary (host) system based on
> control ID
> c) Access remote system and remove auxiliary image records from files
> resident here based on control ID.
>
>
> I'm wondering if other people have had to do something similar and what
> options they've tried.
>
> So far I've been seeing simple FTP and use of DDM.  Never liked DDM
> personally and I'd prefer something that is SQL based if possible.
>
> Have a good day.
>
>
> Blake Moorcroft
> Analyst/Programmer - Corporate
> Russell A. Farrow Limited
> 2001 Huron Church Road, PO Box 333, Windsor, Ontario N9A 2L6
> Bus: 519-966-3003 ext. 566
> blake.moorcroft@xxxxxxxxxx
>
>
>
> Celebrating a Century of Excellence and once again named one of Canada's
> 50 Best Managed Companies!
>
> This electronic message contains information from Russell A. Farrow
> Limited, Russell A. Farrow (U.S.) Inc., canadaplus.com or RAF Express
> Inc., that may be confidential or privileged. The information in this
> electronic message is only for the use of the intended recipient.
> Inappropriate disclosure, copying, distribution or other use of the
> contents of this electronic message is strictly prohibited. If you have
> received this electronic transmission in error, please notify the sender
> immediately by return e-mail. Thank you.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.