RE: Access a MS Sql Table from the AS/400

If it doesn't have to be real time, You can extract the data on the AS400
and FTP the file to the SQL Server box and have a Job Schedule procedure
Import the data.  The Import Job can be set to run every 5 Mins, etc for
example.

HTH

|-----Original Message-----
|From: midrange-l-admin@midrange.com
|[mailto:midrange-l-admin@midrange.com]On Behalf Of
|bacollins@mail.cyber-south.com
|Sent: Thursday, May 23, 2002 9:08 AM
|To: midrange-l@midrange.com
|Subject: Access a MS Sql Table from the AS/400
|
|
|
|I have search the archives but could not find an example of
|hot to setup on
|the AS/400 to access a table on the Micro$oft SQL Server. We
|are running a
|270 with V5R1. I need to be able to do an Insert, Delete and
|Update to the
|table on the Micro$oft SQL Server from the AS/400. I want to read an
|DB2/400 File and then do the Insert, Delete or Update to the
|Micro$oft SQL
|Server.
|
|If anyone has done this I would appreciate the help.
|
|Bruce "Hoss" Collins
|_______________________________________________
|This is the Midrange Systems Technical Discussion (MIDRANGE-L)
|mailing list
|To post a message email: MIDRANGE-L@midrange.com
|To subscribe, unsubscribe, or change list options,
|visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
|or email: MIDRANGE-L-request@midrange.com
|Before posting, please take a moment to review the archives
|at http://archive.midrange.com/midrange-l.
|
|