Answer / Vinita Saini

SQLCA (SQL Communication Area) in DB2 has a fixed size of 168 bytes. However, it can be extended by adding user-defined areas at the end.

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---

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,

---

What is the maximum size of varchar data type in db2?

1 Answers  

---

What is the difference between drop table and delete table?

1 Answers  

---

What is lock escalation?

2 Answers  

---

is it compulsory commitment control in journal?

1 Answers   TCS,

---

Return code 100 means?

6 Answers   Cap Gemini,

---

What is a precompiler?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is a lock?

1 Answers  

---