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

class TestIbmDb2 < Test::Unit::TestCase

  def test_121
    assert_equal expected, capture {
      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
        puts"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"