AS400 DB2 SQL linked server to a MS SQL server


Like we have linked server queries on a MS SQl server to read/write etc to a AS400 DB2 table. I would like to do the reverse and read/write tables from a AS 400 DB2 server to MS SQL server.

Is this possible?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

everything is possible !
but you will need a middleware product such as ibm websphere federation server
that product knows how to simulate various data sources (and sql server among them) as db2 database and enables to do what you desire

your second approach is to use dts / ssis / tsql to pull the data out of as400 and insert it into your sql server
Shalom CarmelCTOCommented:
a federation server is really expensive to buy and deploy.

alternatively you can work with Java and JDBC on iSeries to access MS-SQL.

another option is to use a JDBC/ODBC bridge like those by DataDirect.

If you really insist on using RPG/COBOl, it is possible to write your own Application requester driver, plug it into the WRKRDBDIRE screen and then use it seamlessly via the CONNECT sql method.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Do you need to write programs on a DB2 server (such as an i5) or do you just need to get data from the DB2 database over to the MS SQL server?  That is, do you need to obtain DB2 data on the DB2 server and process it directly on the DB2 server before linking to MS SQL server?  If you do not need to actually program on the DB2 server then you can pull from the DB2 server to MS SQL server via programs on the MS SQL server.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.