CREATE FUNCTION MYFUNC ( VALUE1 INTEGER, VALUE2 INTEGER )
	RETURNS TABLE (VALUE INTEGER, ORDER INT)
	NO EXTERNAL ACTION
F1: BEGIN ATOMIC
	DECLARE ORDER_FROM, ORDER_TO INT;

	SET ORDER_FROM = (SELECT ORDER FROM A.MYTABLE WHERE VALUE = VALUE1);
	SET ORDER_TO = (SELECT ORDER FROM A.MYTABLE WHERE VALUE = VALUE2);
	RETURN
		SELECT VALUE, ROW_NUMBER() OVER (ORDER BY (CASE WHEN ORDER_FROM <
			ORDER_TO THEN ORDER ELSE -ORDER END) ASC) ORDER
		FROM A.MYTABLE
		WHERE (ORDER_FROM < ORDER_TO 
				AND ORDER BETWEEN ORDER_FROM AND ORDER_TO)
			OR (ORDER_FROM >= ORDER_TO
				AND ORDER BETWEEN ORDER_TO AND ORDER_FROM);
END