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

class TestIbmDb2 < Test::Unit::TestCase

  def test_120
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      if conn
        stmt = DB2::exec( conn, "SELECT * FROM animals" )
      
        name1 = DB2::field_name( stmt, 1 )
        name2 = DB2::field_name( stmt, 2 )
        name3 = DB2::field_name( stmt, 3 )
        name4 = DB2::field_name( stmt, 4 )
        
        name5 = DB2::field_name( stmt, "ID" )
        name6 = DB2::field_name( stmt, 8 )
        name7 = DB2::field_name( stmt, 0 )
        name8 = DB2::field_name( stmt, "weight" )
        
        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(4) "NAME"
string(6) "WEIGHT"
bool(false)
string(2) "ID"
bool(false)
string(2) "ID"
bool(false)