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

class TestIbmDb2 < Test::Unit::TestCase

  def test_003
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      if conn
        sql = 'UPDATE animals SET id = 9'
        res = DB2::exec(conn, sql)
        puts "Number of affected rows: #{DB2::num_rows(res)}"
        DB2::close(conn)
      else
        puts"Connection failed."
      end
    }
  end

end

__END__
Number of affected rows: 7