Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: SQL7008 not valid for operation


    I am using MS SQL Server to connect to iSeries DB2 on AS/400 with Linked Server through ODBC DSN. I was able to run SELECT using four-part naming convention in MS SQL Query Analyzer. But INSERT is not working. Here's my query:-

    VALUES ('VAL1')

    It generates the following error.

    OLE DB provider 'MSDASQL' reported an error.
    [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - TABLE1 in SCHEMA1 not valid for operation.]

    Needless to mention that StarSQL executes the query without errors.

    The file is not journaling. I have already set COMMIT to *NONE. So it should work in SQL Query Analyzer. But it does not.

    Any ideas? Thanks.

  2. #2
    Join Date
    Feb 2008

    If the iSeries files has no members

    If the iSeries files has no members you will also get the same error. Try adding one member to the file.

Posting Permissions

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