hello guys,

I have the following procedure :

CREATE PROCEDURE get_seq (IN seq_name varchar(100), out seq_value DECIMAL(12,0) )
LANGUAGE SQL
BEGIN
DECLARE inSeqname varchar(100);
SET inSeqname = 'mySchema.' || seq_name ;
-- set the value here
VALUES NEXTVAL FOR inSeqname INTO seq_value;
END

I would like to pass the name of the sequence and retrieved it but
I can not even generate the code in DB2 , can you guys
see anything wrong with this ?

thank you for your help

Mark Oliva