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

I'm not sure how to natively on the iSeries but we do it with VB. We read
SQLServer data out of our maintenance package and write data into DB2. I'm
sure you could do it in reverse.




Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    rob@dekko.com
                    Sent by:                   To:     midrange-l@midrange.com
                    midrange-l-admin@mi        cc:
                    drange.com                 Subject:     Re: Access a MS Sql 
Table from the AS/400


                    05/23/02 02:44 PM
                    Please respond to
                    midrange-l






This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Microsoft bashing has it's place.  But do you release how this inhibits
searching the archives?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




bacollins@mail.cyber-south.com
Sent by: midrange-l-admin@midrange.com
05/23/2002 09:08 AM
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Fax to:
        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.



_______________________________________________
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.