How do I add a column to a table in db2?

0 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

What is phantom read in db2?

0 Answers  

---

What is check constraint in db2?

0 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---