If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > -910 error.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-22-06, 08:40
Ayusman Ayusman is offline
Registered User
 
Join Date: Nov 2005
Posts: 16
-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
Reply With Quote
  #2 (permalink)  
Old 05-22-06, 08:45
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Start here please

Must Read before posting

Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 05-22-06, 15:44
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
-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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On