Answer / s

Lock contention occurs when an application program is
trying to acquire a lock that is held by another
application program.

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1 Answers  

---

What is view db2?

1 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 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  

---

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

3 Answers  

---

Explain an outer join?

1 Answers  

---

What are the various isolation levels possible?

1 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---