Toad World® Forums

comments lost in udf


#1

Message from: john.enevoldson_671

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


Historical Messages

Author: john.enevoldson_671
Date: Fri Sep 03 08:38:43 PDT 2010
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
__