For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

What is a result table?

1 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

---

What is QUIESCE?

2 Answers  

---

What is buffer pool and list some of them?

0 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

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

2 Answers   Accenture,

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What db2 400?

0 Answers  

---