Answer Posted / lu

your question is not clear.....

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2219

---

When do you specify the isolation level?

1068

---

What is the max length of sqlca?

1265

---

What is the result of open cursor statement?

1125

---

What is cobol db2?

1039

---

Is schema the same as database?

1098

---

How to execute stored procedure in db2 command editor?

1093

---

How to retrieve rows from a db2 table in embedded sql?

1438

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2905

---

Mention the downsides of page level lock.

1212

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141

---

What is an instance database?

1093

---

Is the primary key a clustered index?

1198

---

Why do we need reorg in db2?

1037

---

Is ibm db2 free?

1061

---