Answer / rana

Copybook is the Facility provided to programmer for putting
the variables or COBOL Code which is common to many
programs. This helps programmer to optimize the code and
able to write the error free code.

Copybook gets included into the program at the time of
compilation from the PDS.

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

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  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

Define db2.

0 Answers  

---

How to find the number of rows in db2 tables?

0 Answers  

---

List some fields from sqlca?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

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

---

What is a cursor in programming?

0 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---