Answer / Alkesh Kumar Mishra

DCLGEN (Data Control Language Generator) is a DB2 command that generates COBOL, PL/I, or SQL source code for application programs. The generated code defines the declarations needed to access DB2 tables, views, and procedures. This tool can help reduce the amount of coding required by developers when working with DB2.

What is the role of the data page in the db2 database?

1 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

what is consistency token

3 Answers  

---

How to find the maximum value in a column in the db2 database?

1 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

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,

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

what is the responsibility of the construction superintendent

1 Answers   Almco,

---