Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Basu Hullur Updating AS/400 Linked Server Tables from SQL Server RE: Updating AS/400 Linked Server Tables from SQL Server

  • April 5, 2006 at 9:46 am

    #631046

    Hi.

    I use Microsoft OLE DB Provider for DB2  (DB2OLEDB) for linking to AS/400 from SQL-Server 2000

    I use OpenQuery for all reading (best performance)

    Have no problem with updating the way described in the article, exept for performance on large tables.

    Anyone know how to process a pass-through update query ?

    That should be fast even in large/huge tables !

    /PG