locked
Migrating Database From DB2 to SQL Server RRS feed

  • Question

  • Hi,

    I have a AS400 database, that needs to be imported to SQL Server. 

    The tables, have no issue. 

    When I try to migrate a AS400 Member as SQL Server Table, I am running into issues. 

    I am trying to select data from a DB2 Member Table Via SQL Server Linked Server, the following commands fail... 

    SELECT * FROM OPENQUERY(LINKEDSERVER,'SELECT * FROM LIBRARY.FILENAME(MEMBERNAME)') 

    OR 

    SELECT * FROM OPENQUERY(LINKEDSERVER,'SELECT * FROM LIBRARY.FILENAME.MEMBERNAME') 

    Please help me migrate a member as table. Thanks

    Thursday, September 20, 2018 5:21 PM

All replies