Answer / s

yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.

what is the process of precompiler?

2 Answers  

---

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,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

What is an access path?

3 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

What is table space in db2?

0 Answers  

---

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

What is buffer pool in the db2 database?

0 Answers  

---

Can you use max on a char column?

0 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---