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.

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

What is difference between rollback and commit?

0 Answers  

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

what is db2 restart?

0 Answers  

---

How do you eliminate duplicate values in db2?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

List down the types of triggers in the db2 database?

0 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---