MVSFORUMS.com

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

how and where will i cast values? in what statements?

DECLARE @rate decimal(9,2);
DECLARE @hrs decimal(9,2);
DECLARE @ans decimal(9,2);
DECLARE @comm char(50);
DECLARE Cur CURSOR

if(typ='A') then
INSERT INTO emp(empno, NAME, typ, rate, hrs)
VALUES (@empno, @NAME, @typ, @rate, @hrs);
FETCH Cur INTO @empno, @NAME, @typ, @rate, @hrs;

elseif(typ='B') ...

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

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

oic.. now, it runs but when i call the stored proc it produces an error: A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatib ...

what do u mean by x type?

oic.. now, it runs but when i call the stored proc it produces an error: A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatib ...

tnx! i know it will work but now, im having problem with my field names..

SELECT no, NAME, type, rate, hrs from HR
UNION
SELECT no, NAME, type, sal, bonus from MIS;

//error: The data types ...

another question..
cursor1 is for the first table and cursor2 for the second table. is it right to use different cursors? or can i use only one cursor?

db2 ESE

for
SELECT <statement>;
OPEN Cursor1;
FETCH <statement>;
WHILE SQLSTATE = '00000' Do
INSERT INTO <statement>;
FETCH <statement>;
END WHILE;
close Cursor1; ...

can u give me an example? union of 2 select statements where there is cursor also.. ty! the samples in the link did not help

how will i perform UNION of SELECT statements in stored procedure?

how can i perform union of those two tables?