Answer / s

CLOSE YES parameter tells DB2 that when DB2 needs to close
datasets when DSMAX is reached, DB2 will choose this
tablespace to be closed.

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,

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

Return code 100 means?

6 Answers   Cap Gemini,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is sqlcode -922 ?

2 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

How do you stop a db2 database in linux?

0 Answers  

---