syntax « db2 « Java Database Q&A





1. IBM DB2 custom function syntax    stackoverflow.com

I have a custom regex DB2 function as follows: -

CREATE OR REPLACE FUNCTION REGEXP_LIKE(SOURCE VARCHAR(3000), REGEX VARCHAR(512), 
MODE VARCHAR(3))

RETURNS INTEGER
FENCED 
NOT DETERMINISTIC
NO SQL
LANGUAGE JAVA
PARAMETER STYLE JAVA
EXTERNAL NAME 'db2_regex:com.ibm.avalanche.udf.regex.Regexp.regexpLike'
NO EXTERNAL ACTION
@
This is ...

2. JDBC:DB2 getConnection syntax    coderanch.com