AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

wht is d/f between union and joins ?

2 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

Describe major components of db2?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

Define sqlca.

0 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---