Create Function

[japuentem]

throwing error when creating function

DB21034E 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 ")" was found following "SULTADO
DECIMAL(6, 3". Expected tokens may include:
"END-OF-STATEMENT". LINE NUMBER=8. SQLSTATE=42601

this is my code

CREATE FUNCTION MAYORRPK(
VALUE1 DECIMAL(6, 3),
VALUE2 DECIMAL(6, 3) )
RETURNS DECIMAL(6, 3)
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
BEGIN ATOMIC
DECLARE RESULTADO DECIMAL(6, 3);
IF (VALUE1 >= VALUE2) THEN
SET RESULTADO = VALUE1;
ELSE
SET RESULTADO = VALUE2;
END IF;
RETURN RESULTADO;
END ;

Any suggestions

[Hevan]

Hi,

Remove semicolumn (;) after end and try. All the best.



CREATE FUNCTION MAYORRPK(
VALUE1 DECIMAL(6, 3),
VALUE2 DECIMAL(6, 3) )
RETURNS DECIMAL(6, 3)
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
BEGIN ATOMIC
DECLARE RESULTADO DECIMAL(6, 3);
IF (VALUE1 >= VALUE2) THEN
SET RESULTADO = VALUE1;
ELSE
SET RESULTADO = VALUE2;
END IF;
RETURN RESULTADO;
END

[japuentem]

I have the same result

Hi,

Remove semicolumn (;) after end and try. All the best.



CREATE FUNCTION MAYORRPK(
VALUE1 DECIMAL(6, 3),
VALUE2 DECIMAL(6, 3) )
RETURNS DECIMAL(6, 3)
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
BEGIN ATOMIC
DECLARE RESULTADO DECIMAL(6, 3);
IF (VALUE1 >= VALUE2) THEN
SET RESULTADO = VALUE1;
ELSE
SET RESULTADO = VALUE2;
END IF;
RETURN RESULTADO;
END

[gast2007]

Looks like you have 1 more "(" than ")"

[Hevan]

This function works fine. did you drop and rebuild the function and run it?

[japuentem]

Looks like you have 1 more "(" than ")"

I counted and i have the same number of "(" and ")"

[japuentem]

This function works fine. did you drop and rebuild the function and run it?

I treated to run with the command editor of db2 and always send me an error.

i don't know what to do