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
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Mention the location where the output received from explain statement is stored.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is dbrm? What it contains?
What are the rules for db2 programming?
What is the use of dclgen in db2?
What is catalog database in db2?
What types of tables are there in the db2 database?
How do I add a column to a table in db2?
what is utility for parm lib
How can the duplicate values be eliminated from db2 select?
Which isolation level provides maximum concurrency?
Why do chiropractors use drop table?
How to access db2 tables in mainframe?
How would you find out the total number of rows in a db2 table?
