Answer / Karamveer Singh

DCLGEN is a DB2 command used to generate DDL statements (CREATE, ALTER, and DROP) for creating or altering database objects. The output from DCLGEN will contain SQL code defining the structure of the specified object(s).

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 cursor?

1 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

How to test SQL -911 error while developing COB-DB2 program

2 Answers   Satyam,

---

What is a Foreign Key?

1 Answers   Tavant Technologies, Zensar,

---

How does db2 sample database connect?

1 Answers  

---

What kind of database is db2?

1 Answers  

---

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

2 Answers   Verizon,

---

When do you specify the isolation level? How?

1 Answers  

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

5 Answers   Mphasis,

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1 Answers  

---