MVSFORUMS.com

[wishlister]

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') then
INSERT INTO emp(empno, NAME, typ, ans, comm)
VALUES (@empno, @NAME, @typ, @ans, @comm);
FETCH Cur INTO @empno, @NAME, @typ, @ans, @comm;
end if;

error//The data types of corresponding columns are not compatible in a fullselect that includes a set operator or in the multiple rows of a VALUES clause of an INSERT or fullselect.

[videlord]

how you define the Cur CURSOR?
what's the data type of the 4th and 5th field of the CURSOR?
is it match with (@rate, @hrs) and (@ans, @comm)?

[wishlister]

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

[wishlister]

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