"smd" <sd******@swbell.net> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com...
I'm noticing a problem with a table on AS400. Basically I'm running a
select * and I'm getting back
Error: SQL0971 - Constraint DIVAPPPRDIV in check pending state.
(State:S1000, Native Code: FFFFFC35)
Any thoughts?
My thought is that you should check the Messages manual for your version of
DB2 and see what additional information it gives you about the problem. That
should be your first action.
Then, if you don't know what the the terms in the message mean, you should
look them up in the various manuals. For example, I suspect you don't know
what "check pending" means otherwise you probably wouldn't be asking this
question. So, assuming you are accessing electronic copies of the manuals,
use the search engine to find out what "check pending" means, what you (or
others) might have done to cause that state, and what you (or the
responsible person) can do to turn off the check pending state.
You'll find that this is a relatively easy problem to understand and,
probably, to rectify.
If you don't understand what you are reading when you find the explanation
for "check pending", ask back here; someone can probably help you. The
manuals are pretty good overall but may not be clear enough if you are a
beginner.
Rhino