what is copy pending and check pending ?
Answer / sasi
COPY PENDING status
A state in which, an image copy on a table needs to be
taken, In this status, the table is available only for
queries. You cannot update this table. To remove the COPY
PENDING status, you take an image copy or use REPAIR
utility.
CHECK PENDING
When a table is LOADed with ENFORCE NO option, then the
table is left in CHECK PENDING status. It means that the
LOAD utility did not perform constraint checking.
| Is This Answer Correct ? | 9 Yes | 3 No |
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is null indicator in db2?
What is a bind card?
my project is insurance management system,how to explain my work environment in interview?
What is the maximum No of rows per page?
What is blu acceleration in db2?
Q4. How will you get the count of record without using COUNT verb in query?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Plan has the optimized access path in it. But is that optimized access path is attained or known
what is cursor stability?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What is the difference between SYNONYM and ALIAS?