Answer / vaneesh khurana

1.compile and run the program,in the spool we can find the
offset value for the job. note that offset value and run
the same job again with compiler option as LIST.
2.see the spool for the offset value where it is
located,means exactly in which numerical operation that
abbend occured.EG: total = salary + commision.

What are the disadvantages of using VARCHAR?

3 Answers  

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

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?

4 Answers   Mphasis,

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

---

How do I delete a table in database?

0 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

Explain the function done by data manager?

0 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---