• These work at my site.  Linked server name is DB2TL

    DELETE FROM DB2TL..WFMM.ACCOUNT;

    INSERT INTO DB2TL..WFMM.ACCOUNT SELECT * FROM ACCOUNT_V4;

     

    If they aren't working, make sure you are not using the OLE Provider for ODBC (I think you are OK there).

    Check authority of the Userid on the table in DB2.

    Lastly, run a dyn sql trace in DB2.