Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


AS400 DB2 SQL linked server to a MS SQL server

Posted on 2008-11-19
Medium Priority
Last Modified: 2013-11-30

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?


Question by:gardmanIT
LVL 37

Assisted Solution

momi_sabag earned 664 total points
ID: 22997168
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
LVL 33

Accepted Solution

shalomc earned 672 total points
ID: 23005069
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.

Assisted Solution

richard_crist earned 664 total points
ID: 23009599
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.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question