Toad World® Forums

comments lost in udf


#1

Hi,
We build the following udf:
CREATE OR REPLACE FUNCTION “PXX”.“PXXDLFTESTTJE” ( )
RETURNS INTEGER
SPECIFIC “PXXDLFTESTTJE”
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
READS SQL DATA
– some comments before begin
BEGIN ATOMIC
– a comment after begin
RETURN
SELECT count(*)
FROM SYSCAT.FUNCTIONS;
– some comments
– some more comments

END;

Build is fine. Close editor. Refresh the explore view and then send the udf to a new
editor. Now we see:

CREATE OR REPLACE FUNCTION “PXX”.“PXXDLFTESTTJE” ( )
RETURNS INTEGER
SPECIFIC “PXXDLFTESTTJE”
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
READS SQL DATA
BEGIN ATOMIC
– a comment after begin
RETURN
SELECT count(*)
FROM SYSCAT.FUNCTIONS;
– some comments
– some more comments

END;

Note the original comment before the BEGIN ATOMIC statement has disappeared. Any chance of fixing this ?

Regards,

John