Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    58

    Unanswered: DML against remote tables (MSSQL to DB2)

    I created a linked server to a DB2 database and I can pull data fine, but when I try to insert/update/delete it tells me "SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C"" when trying: DELETE FROM DB2LinkedServer..SPACENAME.TABLENAME

    I believe I need to send a clear string to DB2 that doesn't get compiled on the sql server side. Is there something like openquery that I can use for DML statements in SQL Server?

  2. #2
    Join Date
    Feb 2002
    Posts
    58
    Upon further review I found this site: http://support.microsoft.com/kb/270119/EN-US/

    It shows how to use openquery to execute DML statements. nifty.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •