Thank you Serge,
Is this the only way out ? So I have to have an SPL
for every functions I have ? We have well over 300
functions....
Thank you!
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:2t*************@uni-berlin.de...
N wrote:
db2 -td%
CREATE PROCEDURE db2.get_type_id (v_type CHAR(2),
OUT RETURN_VAL INTEGER)
LANGUAGE SQL
CONTAINS SQL BEGIN
DECLARE v_cat_type INTEGER;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION,
SQLWARNING,
NOT FOUND
BEGIN
SET v_cat_type = 7;
END;
IF v_type <> '' THEN
SET v_cat_type = DOUBLE(v_type);
ELSE
SET v_cat_type = 7;
END IF;
SET RETURN_VAL = v_cat_type;
RETURN 0;
END
%
CREATE FUNCTION db2.get_type_id (v_type CHAR(2)
RETURNS INTEGER
CONTAINS SQL DETERMINISTIC NO EXTERNAL ACTION
BEGIN ATOMIC
DECLARE RETURN_VAL INTEGER;
CALL db2.get_type_id (v_type, RETURN_VAL);
RETURN RETURN_VAL;
END
% SELECT
col_id,
db2.get_type_id (col_type_id)
FROM
db2.table_name
%
Cheers
Serge