Answer / guest

You add the keyword "WITHHOLD" to the declare statement of
the cursor

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

Are view updateable?

0 Answers  

---

Update command

1 Answers  

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

Explain packages.

0 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---