What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What type of database is db2?

0 Answers  

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

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  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

What is null value in db2?

0 Answers  

---

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

3 Answers  

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---