Answer / lu

union for the row...
joins for a column...

Answer / amarnath reddy

use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;

use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

How to restart a DB2 program?

1 Answers   Cognizant,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

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 ?...

1 Answers   IBM,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

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

1 Answers  

---

Give a brief description of db2 isolation levels?

1 Answers  

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1 Answers  

---

What is an intent lock?

3 Answers  

---

What is the purpose of rollback and commit?

1 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---