/**
 * JDBC Хранимая процедура SAV.PROB3
 */ 
package sav;

import java.sql.*;                   // Классы JDBC

public class Prob
 123 ;
    public static void printTable (String name, ResultSet[] rs1 ) 
                                        throws SQLException, Exception
     123 ;
        // Получить соединение с базой данных
        Connection con = DriverManager.getConnection( "jdbc:default:connection" );
        PreparedStatement stmt = null;
        boolean bFlag;
        String sql;

        sql =  "SELECT * from sav."  + name;
        stmt = con.prepareStatement( sql );
        bFlag = stmt.execute();
        rs1[ 0 ] = stmt.getResultSet();
     125 ;
 125 ;

jar cf sav.jar sav/

Call sqlj.install_jar ('file:///C:/DB2/SAV.jar', 'SAV',  0 )

Call sqlj.refresh_classes( )

Call sqlj.updatejarinfo ('SAV', 'prob.PROB3', '???')
                                                      чего там писать?

CREATE PROCEDURE sav.PrintTab(IN name CHAR[ 100 ],
                 OUT res CHAR[ 255 ])
EXTERNAL NAME 'SAV:Prob.PrintTable'
LANGUAGE JAVA 
PARAMETER STYLE JAVA

 /**
 * JDBC Хранимая процедура SAV.PROB3
 */ 
import java.sql.*;                   // Классы JDBC
public class Prob
 123 ;
    public static void printTable (String name, ResultSet[] rs1 ) 
                                        throws SQLException, Exception
     123 ;
        // Получить соединение с базой данных
        Connection con = DriverManager.getConnection( "jdbc:default:connection" );
        PreparedStatement stmt = null;
        boolean bFlag;
        String sql;

        sql =  "SELECT * from "  + name;
        stmt = con.prepareStatement( sql );
        bFlag = stmt.execute();
        rs1[ 0 ] = stmt.getResultSet();
     125 ;
 125 ;

CREATE PROCEDURE sav.PrintTable (IN name CHAR( 10 ))
DYNAMIC RESULT SETS  1 
LANGUAGE JAVA 
PARAMETER STYLE JAVA
NO DBINFO
FENCED
READS SQL DATA
PROGRAM TYPE SUB
EXTERNAL NAME 'Prob.printTable';

call sav.PrintTable('test');

[IBM][CLI Driver][DB2/NT] SQL0444N  User defined function  "SAV.PrintTable"  (specific name  "SQL031003125538850" ) is implemented with code in library or path  "\sav.PrintTable" , function  "sav.PrintTable"  which cannot be accessed.  Reason code:  "4 ".  SQLSTATE= 42724 

 --------------------------- Command entered ----------------------------
 
call sav.PrintTable('test');
 ------------------------------------------------------------------------
 
call sav.PrintTable('test')
SQL1109N  The specified DLL  "sav.PrintTable"  could not be loaded.

- 1109