Dynamically determine the type of a variable in stored procedures in DB2
Is it possible to dynamically determine the type of a variable in a stored procedure with a column type in the table.
I want to set a type
DECLARE at_end SMALLINT DEFAULT 0; DECLARE myVar VARCHAR(21); -- It should be the type of mytable.mycolumn
In Oracle, this is possible with
How does it work in DB2 9.7 ??
source to share