create procedure proctest3(in name varchar( 50 ), out id bigint)
 language sql
begin
 set id=nextval for level_0;
 insert into test.t(test.t.id, test.t.name) values(id, name);
end

      
 Class.forName("com.ibm.db2.jcc.DB2Driver");
 Connection con=DriverManager.getConnection("jdbc:db2://localhost:50000/tdb","username","password");
 CallableStatement cst=con. prepareCall("{call test.proctest3(?,?)}");
 cst.setString("name", data);
 cst.registerOutParameter( 1 ,java.sql.Types.VARCHAR);
 cst.executeUpdate();