Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kamal singh
It comes into existencw when constraint checking is
suspended for a particular table. Let me explain with the
help of an example:
If we want to temporarily suspend constraint checking for a
table named EMPLOYEES and deny read-only access to that
table while constraint checking is turned off, we could do
so by executing a SET INTEGRITY statement that looks
something like this:
SET INTEGRITY FOR EMPLOYEES OFF
When constraint checking is suspended for a particular
table, that table is placed in "Check Pending" state to
indicate that it contains data that has not been checked
(and that may not be free of constraint violations). While
a table is in "Check Pending" state, it cannot be used in
insert, update, or delete operations, nor can it be used by
any DB2 UDB utility that needs to perform these types of
operations. In addition, indexes cannot be created for a
table while it is in "Check Pending" state, and data stored
in the table can be retrieved only if the access mode
specified when the SET INTEGRITY statement was used to
place the table in "Check Pending" state allows read-only
access.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How do you select a row using indexes in db2?
What is the purpose of rollback and commit?
What is dbrm in db2 database?
What is the connection string to connect to the DB2 Database ?
What does db2 mean?
How to connect to db2 database from windows command line?
What is db2?
What is dbrm?
How do I copy a table in db2?
List out the data types available.
How can we retrieve the total number of records in RPG & CLLE?
What r the comman abends in db2, jcl and cobol???????
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do I add a column to an existing table in db2?
What is the purpose of using commit?
