Re: Looking for suggestions on a data transfer automation

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.