Getting a sql Error, db2 function error return result

Question

My Function is getting a error but I don't know why ...

MY (DB2)SQL CODE:

CREATE FUNCTION gibX(sseries INTEGER, idd INTEGER) RETURNS Double
 BEGIN
   Declare result Double;
   SELECT ROW_NUMBER() OVER(ORDER BY m.x ASC) AS Row, m.x  INTO result 
   FROM messungen m WHERE m.series=sseries and Row=idd;
   return result;
 END;

ERROR:

CREATE FUNCTION;
   return result;
;, DRIVER=4.13.80

... and passed successfully.

Gordon Linoff · Accepted Answer · 2017-12-01 23:59:25Z

1

You cannot reference row in the where. One method is a subquery:

SELECT x INTO result
FROM (SELECT ROW_NUMBER() OVER (ORDER BY m.x ASC) AS Row, m.x  
      FROM messungen m
      WHERE m.series = sseries
     ) m
WHERE Row = idd;

answered Dec 1, 2017 at 23:59

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting a sql Error, db2 function error return result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related