MVSFORUMS.com

[wishlister]

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0506melnyk/
under listing 3.
that's what im trying..
i want to combine salesperson and engineer tables in one table with their respective column fields. and if the column does not apply to them, it will be left as blank.

[kolusu]

wishlister,

You are very poor at explaining as to what you are trying to do. In the link(listing 3) given there are no columns named rate or hrs or the tables HR or MIS. How are we supposed to help you ?

As I mentioned earlier show us the column defintions of tables HR and MIS and also the target table which you are trying to insert these values into.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[wishlister]

create type EMP as
(empno char(6),
name varchar(50),
dtype varchar(11))
ref using integer
mode db2sql

create type HR under EMP as
(rate decimal(9,2),
hrs decimal(9,2))
mode db2sql

create type MIS under EMP as
(sal decimal(9,2),
bonus decimal(9,2))
mode db2sql

create table EMP_t of EMP
(ref is OBJID user generated,
EMPNO with options not null)

create table HR_t of HR
under EMP_t
inherit select privileges

create table MIS_t of MIS
under EMP_t
inherit select privileges

create table employees
(empno char(6) not null,
name varchar(50) not null,
dtype varchar(11) not null,
rate decimal(9,2),
hrs decimal(9,2),
sal decimal(9,2),
bonus decimal(9,2),
primary key(empno))

[wishlister]

how will i join the two tables(MIS_t and HR_t) in one table

[kolusu]

wishlister,

You don't need an union to just insert rows from 2 tables into a single table. try this