Answer / naveen87ginjupalli

SQLCODE, SQLERRM, SQLERRD.

How will you delete duplicate records from a table?

7 Answers   Google,

---

What are the various locking levels available?

3 Answers  

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 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,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is the difference between static and dynamic SQL?

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

can we drop column from a table

7 Answers   INDUS,

---

where will u check for sqlcode ?

2 Answers   TCS,

---