require 'ibm_db2'
require 'stringio'
require 'test/unit'

class TestIbmDb2 < Test::Unit::TestCase

  def test_221
    assert_equal expected, capture {
      for (i = 1; i <= 500; i++)
        pconn[i] = DB2::pconnect(database, user, password)
      end
      
      if pconn[333]
        conn = &pconn[222]
        stmt = DB2::exec( pconn[333], "UPDATE animals SET name = 'flyweight' WHERE weight < 10.0" )
        puts"Number of affected rows: " . DB2::num_rows( stmt )
        DB2::close(pconn[333])
      else
        puts"Connection failed."
      end
    }
  end

end

__END__
Number of affected rows: 4