Will Calling a Procedure from user defined function work in DB2 v8 for
Windows????

it throws the below error while i try to compile:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "CALL TEMP_GET_INT_VARIABLE" was found
following
"ALUE INT default 0; ". Expected tokens may include: "<compound_return>".
LINE NUMBER=7. SQLSTATE=42601


Example:
---------------------------------------------------------------------------
CREATE PROCEDURE TEMP_GET_INT_VARIABLE(p_v int)
RESULT SETS 0
LANGUAGE SQL
NOT DETERMINISTIC
BEGIN
DECLARE var int;
END
@

CREATE FUNCTION GET_INT_VARIABLE(P_VAR_NAME VARCHAR(2000))
RETURNS INT
LANGUAGE SQL
MODIFIES SQL DATA
BEGIN ATOMIC
DECLARE INT_VALUE INT default 0;
CALL TEMP_GET_INT_VARIABLE(1);
RETURN INT_VALUE;
END
@
---------------------------------------------------------------------------

appreciate any help regarding this problem....

Jay


DB2 & UDB email list listserv db2-l LazyDBA home page