Mention some fields that are a part of sqlca.

0 Answers  

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 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,

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

What is meant by the attachment facility?

3 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?

0 Answers   HeadStrong,

---

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

9 Answers   CTS, IBM, TCS,

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---