Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / thiru
It is a state of the table being locked due to constraint
violation.
For eamaple if you try to nullify the master table alone
and reloading it with some additional records without
deleting detail table records or vise versa, the master and
the child tables whill go to the check pending state.
You can check the same with the help of the below query.
select tabname from syscat.tables where status='C';
To clear the same we can use the following statements.
set integrity for master immediate checked for exception in
master use exception_table;
the violated records will be moved to exception table and
the check pending will be cleared.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why do we use cursor?
What are catalog tables in db2?
Define data page.
What is rebind in db2?
How do you select a row using indexes in db2?
What does runstats do in db2?
How to take backup of table in db2?
What is the difference between using bind () and rebind () methods of naming class?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a buffer in memory?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How do you eliminate duplicate values in db2?
What is a db2 package?
What is the maximum length of sqlca?
