Post reply

Using a stored procedure to get data from DB2

  • August 24, 2006 at 7:49 am

    #367183

    Is it possible to retrive data from AS/400 DB2 with a stored procedure and insert the data in a temporary table? The reason I want to do this is that I have some data in SQL2000 and some data in DB2. Then I want to process the data from DB2 and combine it with the data in SQL2000

  • August 24, 2006 at 3:51 pm

    #656733

    If you have an ODBC driver for the AS/400 DB2, you can create a linked server to it from SQL Server. Then you'll be able to query it using the OPENQUERY syntax (check BOL for details).

  • August 27, 2006 at 11:43 pm

    #657023

    Thanks;

    Will try this.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply