CREATE FUNCTION using JDBC connection

Hi,

Run it like this:

--/ CREATE FUNCTION myzeroifnull(x INT) RETURN INT AS BEGIN RETURN (CASE WHEN (x IS NOT NULL) THEN x ELSE 0 END); END; /

Or, you should be able to execute the entire buffer using the 'SQL Commander/ Execute Buffer' menu selection. According the the documentation for DbVisualizer:
Execute Buffer sends the complete editor buffer for execution as one statement. No comments are removed and no parsing of individual statements based on any delimiters is made. This operation is useful when executing SQL blocks or SQLs used to create procedures, functions, etc.

Thanks, the block start / end needs to be in new lines and it works