Re: Looking for suggestions on a data transfer automation

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Use QNTC. Share a drive from the iSeries. Have the SQL Server map to the
drive. Use CPYTOIMPF (or roll your own) to create the CSV file on the shared
drive, which would be an IFS directory. A process on the SQL server would
grab the CSV file and do what it needs to do.

On Fri, May 15, 2009 at 12:33 PM, Valerio Vincenti <
vvincenti@xxxxxxxxxxxxxxxxxx> wrote:

> I have a Client Access data transfer that grabs a DB2 file on the 400 and
> creates a .CSV file on a MS SQL server sitting on our network (overwriting
> the existing file).
> I manually run the data transfer from a PC connected to the 400 which has
> the target SQL server mapped to it.
>
> I need to automate this process but I'm not sure whether I should be
> looking at FTP or Remote Commands or other.
>
> Thanks for any help!
>
> Valerio Vincenti
> IT Business Analyst
> County of Spotsylvania, I.S. Department
> Spotsylvania, VA 22553
> Phone (540) 507-7507
> Fax (540) 582-9841
> e-mail: vvincenti@xxxxxxxxxxxxxxxxxx
> --
> 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.