class TestIbmDb2 < Test::Unit::TestCase

  def test_121
    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"
        name1 = DB2::field_name stmt, 0
        name2 = DB2::field_name stmt, 1
        name3 = DB2::field_name stmt, 2
        name4 = DB2::field_name stmt, 3
        name5 = DB2::field_name stmt, "BREED"
        name6 = DB2::field_name stmt, 7
        name7 = DB2::field_name stmt, '"Number"'
        name8 = DB2::field_name stmt, "NUMBER"
        var_dump( name1 )
        var_dump( name2 )
        var_dump( name3 )
        var_dump( name4 )
        var_dump( name5 )
        var_dump( name6 )
        var_dump( name7 )
        var_dump( name8 )
      else
        print "Connection failed."
      end
    }
  end

end

__END__
string(5) "BREED"
string(6) "NUMBER"
bool(false)
bool(false)
string(5) "BREED"
bool(false)
bool(false)
string(6) "NUMBER"