Uh huh. "..." That's not much help.

...

I'm not certain what it means to have EXECUTE privilige on
SQLJ.INSTALL_JAR but I can run java programs.

I tried various:

call sqlj.install_jar('file://W:/Program
Files/IBM/SQLLIB/FUNCTION/",UdfUtils.jar',0);

And used this SQL to register RegEx as:

CREATE FUNCTION RegExp(pattern VARCHAR(2048), string CLOB(10M))
RETURNS INTEGER
FENCED
VARIANT
NO SQL
LANGUAGE JAVA
PARAMETER STYLE JAVA
EXTERNAL NAME 'com.rh.bb.udf.utils.RegExp!Match'

I named the jar file UdfUtils.jar .

I placed it in:

W:\Program Files\IBM\SQLLIB\FUNCTION/UdfUtils.jar

And FYI :

jar tvf UdfUtils.jar
    0 Tue Mar 28 01:39:38 PST 2006 META-INF/
   55 Tue Mar 28 01:39:38 PST 2006 META-INF/MANIFEST.MF
    0 Tue Mar 28 01:39:38 PST 2006 com/
    0 Tue Mar 28 01:39:38 PST 2006 com/rh/
    0 Tue Mar 28 01:39:38 PST 2006 com/rh/bb/
    0 Tue Mar 28 01:39:38 PST 2006 com/rh/bb/udf/
    0 Tue Mar 28 01:39:38 PST 2006 com/rh/bb/udf/utils/
  703 Tue Mar 28 01:39:38 PST 2006 com/rh/bb/udf/utils/RegExp.class

Here is RegExp.java:

package com.rh.bb.udf.utils;

import java.sql.Clob;

import java.util.regex.Pattern;
import java.util.regex.Matcher;

import COM.ibm.db2.app.UDF;

public class RegExp extends UDF {

   public static int Match(java.lang.String pattern, java.sql.Clob
clob)
   {
         Pattern p = Pattern.compile(pattern);
           Matcher m = p.matcher(
clob.getSubString(Long.parseLong("1"), (int)clob.length()) );
           if ( m.matches() ) {
               return 1;
           }
           return 0;
   }
}

I also couldn't get the simpler testUDF method to work. (It's not in
the jar shown above but once it was.) Here it is:

package com.rh.bb.udf.utils;

import java.sql.*;

import java.lang.*;

import COM.ibm.db2.app.*;

class DB2Appl1 extends UDF {

public static int testUDF(int value1, int value2)
   {
       try
       {
           return(value1 & value2);
       }
       catch (Exception e)
       {
           return 0;
       }
   }
}

upon executing RegEx(table.someclob) , or testUDF, nothing not a zero,
not a one is returned, and there are no error messages.

I couldn't find any log files that had any traces suggesting errors.

Didn't have to do that.