By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Error: SQL0971

P: n/a
smd
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?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.