What are the benefits of using the db2 database?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

how will you retrieve first record in table

1 Answers   UST,

---

What is runstats and reorg in db2?

0 Answers  

---

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is auditing?

2 Answers  

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is lock escalation?

2 Answers  

---

What is dclgen (declaration generator)?

0 Answers  

---