Explain correlated sub-queries.

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

Explain the function done by data manager?

0 Answers  

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---

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 PRIME TABLE and what are the uses of it

1 Answers  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 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,

---