CREATE FUNCTION using JDBC connection
I'm using DBVisualizer to connect to vertica (with JDBC connection).
I tried to create a simple function from myVertica page:
CREATE FUNCTION myzeroifnull(x INT) RETURN INT AS BEGIN RETURN (CASE WHEN (x IS NOT NULL) THEN x ELSE 0 END); END;
It works with vsql, but doesn't work using JDBC with DBVisualizer.
I get this error:
ERROR: Syntax error at or near "EOL"
Its not possible to create function this way?