Answer / s

DSNC is a CICS command processing transaction used to issue
attachment commands to display and control the CICS
attachment facility. After a connection between CICS and
DB2 is established, DSNC is used to issue DB2 commands to
DB2 system.

What is dbrm in db2 database?

1 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

What is the use of db2?

1 Answers  

---

what is utility for parm lib

1 Answers   IBM,

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

When do you specify the isolation level?

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

---

List out the data types available.

1 Answers  

---

B37 abend during spufi?

1 Answers   IBM,

---

What are foreign keys?

1 Answers  

---