Results 1 to 3 of 3

Thread: -910 error.

  1. #1
    Join Date
    Nov 2005
    Posts
    16

    Unanswered: -910 error.

    Hi All,
    I am getting this while running an batch job on my database,

    DB2 SQL error: SQLCODE: -910, SQLSTATE: 57007, SQLERRMC

    Any suggestions pointing to it's cause and cure please??

    TIA

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    -910 THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH A DROP OR ALTER
    IS PENDING

    Explanation: The application program has issued a DROP or ALTER against
    an object, and then attempted to access that object before the DROP or
    ALTER is completed.

    Programmer Response: In the case of ALTER, the logic of the application
    program must be modified so that a COMMIT (or the IMS or CICS equivalent)
    is executed between the ALTER and the failing SQL statement.

Posting Permissions

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