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.

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

How does a cursor work?

0 Answers  

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What is package in db2 mainframe?

0 Answers  

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

What is the max length of sqlca?

0 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

What is meant by the attachment facility?

3 Answers  

---