AS400 to SQL Server

Question

AS400 to SQL Server

El Hulk

SSC Enthusiast

Points: 114
More actions
May 5, 2005 at 8:29 am

#61132

I'm totally new using AS400 but I have to import some tables from an AS400 system to a SQL Server 2000 DB, any ideas on how can I accomplish this task?
Thanks in advance.

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

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

Rajesh Hegde Right there with Babe Points: 761 More actions · Answer 1

Try generating text files or excel files out of the AS400 database and then use DTS to import the data in the files to SQL server tables.

Hope this answers your question.

El Hulk SSC Enthusiast Points: 114 More actions · Answer 2

Rajesh,

Thanks for your answer, I tried that but the text files came in a really bad format, even thought I exported them as tab delimmited, comma delimited and any other option I could find, also the AS400 do not export the column names.

jablakejr Grasshopper Points: 17 More actions · Answer 3

We do this every day. Either of the following solutions can be 'packaged' to run as jobs on a regular schedule.

With a remote/linked server connection defined using IBM CLient Access, we do selects from openquery(linkedservername, 'Select .... from AS400Catalog.AS400Library.AS400Table') against multiple AS400 DB2 tables.

I have also used a 4-part server/db syntax, such as the following: Select datacolumns from AS400name.AS400Catalog.AS400Library.AS400Table.

You use linked server name, AS400's base catalog (usually the AS400 server name for IP access), the library name where the DB tables reside, and the table name you want to use. You may have to use quoted identifiers depending upon your setup.