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
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are the 2 sqlcodes that are returned?
What is the difference between oracle and db2?
What is data manager?
How to create db2 table in mainframe?
Name the various locking levels available?
What is ibm db2 used for?
How to execute stored procedures?
Which isolation level provides maximum concurrency?
What are the rules for db2 programming?
is it compulsory commitment control in journal?
Why do we need reorg in db2?
How can we read records for specific member in CL? AND rpg?
What is coalesce in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
