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.

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

0 Answers  

---

---

What is a correlated sub query?

2 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is bind package and plan in db2?

0 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

When is the access path determined for dynamic SQL?

2 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---