Answer / sadiq afroze

DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes

What are data types?

2 Answers  

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

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,

---

What is the use of predicate?

0 Answers  

---

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

Define buffer pool.

0 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

Can there be more than one cursor open for any program?

0 Answers  

---

What is bufferpool in db2?

0 Answers  

---