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 does coalesce work?
If I have a view which is a join of two or more tables, can this view be updateable?
Highlight all the advantages that are attached to a package.
What is rebind in db2?
What is db2 plan table?
What is cobol db2?
List some fields from sqlca?
Why do we bind in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is null in db2?
B37 abend during spufi?
How to test SQL -911 error while developing COB-DB2 program
What is a db2 table?
What are bind parameters in db2?
i want to maintain uniqueness on pdf without make lf??????????
