/**
 * JDBC Хранимая процедура DB2ADMIN.GET_PROC
 * @param tdp_code
 * @param y
 */
package PKG90314084451010;

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

public class GET_PROC
{
    public static void gET_PROC ( int tdp_code,
                                  int y,
                                  ResultSet[] rs1 ) throws SQLException, Exception
    {
        // Получить соединение с базой данных
        //Connection con = DriverManager.getConnection("jdbc:default:connection");
        Class.forName("com.ibm.db2.jcc.DB2Driver");
        Connection con = DriverManager.getConnection("jdbc:db2://192.168.0.1:50000/STRAH","db2inst","db2inst");
        PreparedStatement stmt = null;
        boolean bFlag;
        String sql;

        sql = "SELECT ter.* FROM TERRITORY ter";
        stmt = con.prepareStatement( sql );
        bFlag = stmt.execute();
        rs1[ 0 ] = stmt.getResultSet();
    }
}