Answer / s

Correlation names are used in the SQL statment as an
alternate name to a qualified table.

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

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,

---

What is the difference between spufi and qmf?

0 Answers  

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

What is syscat in db2?

0 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---