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

    Unanswered: SQL7008 not valid for operation

    Hi

    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:-

    INSERT INTO LINKEDSERVER1.CATALOG1.SCHEMA1.TABLE1 (COL1)
    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
    Posts
    2

    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
  •