What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

What is the use of value function?

0 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What parameters are used to control the free space in DB2?

0 Answers  

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

What is meant by union and union all?

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

where will u check for sqlcode ?

2 Answers   TCS,

---