Answer / s

If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

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?

0 Answers   HeadStrong,

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

cobol-db2 runjcl please?

2 Answers   DELL,

---

What is buffer pool in the db2 database?

0 Answers  

---

When would you prefer to use VARCHAR?

3 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

Explain about dbrm.

0 Answers  

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

What does DSNDB07 database do?

2 Answers  

---