AS400 & SQL SERVER 2000

• Vandy

  SSCommitted

  Points: 1827

  More actions

  April 11, 2007 at 5:34 am

  #75143

  Hi

  I need to extract data from AS400 to SQL SERVER 2000.

  Which is the best way to do this so that i can show live reports by updating my table after some time interval?

  I have iSeries Navigator version 5 Installed on my server but it's new for me is it helpful? Right now i am using Routeone for extraction.

  Thanks

   

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  April 11, 2007 at 9:50 am

  #699822

  Create a DSN on the SQL Server box using the Client Access ODBC driver.

  This DSN should point to the AS400 libraries you want to use.

  Add the AS400 server as a linked server to the SQL Server, using the DSN you created as the provider string, thus DSN=<YOUR DSN NAME>.

  Product should be DB2

  You should then be able to directly query your AS400 tables using something like this:

  SELECT * FROM OPENQUERY(<your linked server name>, 'SELECT * FROM <DATABASENAME>.<LIBRARYNAME>.<TABLENAME>')