class TestIbmDb2 < Test::Unit::TestCase

  def test_111
    assert_expect {
      conn = DB2::connect database, user, password
      if conn
        insert = "INSERT INTO animals values (7, 'cat', 'Benji', 5.1)"
        DB2::exec conn, insert
        stmt = DB2::exec conn, "SELECT breed, COUNT(breed) AS number FROM animals GROUP BY breed ORDER BY breed"
        num1 = DB2::field_num stmt, "ID"
        num2 = DB2::field_num stmt, "BREED"
        num3 = DB2::field_num stmt, "NUMBER"
        num4 = DB2::field_num stmt, "number"
        num5 = DB2::field_num stmt, "Breed"
        num6 = DB2::field_num stmt, 8
        num7 = DB2::field_num stmt, 1
        num8 = DB2::field_num stmt, "weight"
        var_dump( num1 )
        var_dump( num2 )
        var_dump( num3 )
        var_dump( num4 )
        var_dump( num5 )
        var_dump( num6 )
        var_dump( num7 )
        var_dump( num8 )
      else
        print "Connection failed."
      end
    }
  end

end

__END__
bool(false)
int(0)
int(1)
bool(false)
bool(false)
bool(false)
int(1)
bool(false)