How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---

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

0 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

What is sqlca’s maximum length?

0 Answers  

---

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

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 does one remove entries from the SCT02 table?

1 Answers  

---