Answer / s

SQLCODE, SQLSTATE, SQLERRD(3)

Answer / c suresh kumar

sqlcode,sqlerrd,dnstair,

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

Can you use max on a char column?

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,

---

What is the use of db2 optimizer?

0 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

What is the FREE command?

1 Answers  

---

What is iseries database?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---