Answer / vamsikrishnamraju

An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained

What is an access path?

3 Answers  

---

How is deadlock resolved?

0 Answers  

---

What is query_cache_limit?

0 Answers  

---

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

What are the various data types available in db2?

0 Answers  

---

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 is database reorganization?

0 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

What do you mean by commit and rollback?

0 Answers  

---