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

class TestIbmDb2 < Test::Unit::TestCase

  def test_110
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      if conn
        stmt = DB2::exec( conn, "SELECT * FROM animals ORDER BY breed" )
      
        num1 = DB2::field_num( stmt, "ID" )
        num2 = DB2::field_num( stmt, "BREED" )
        num3 = DB2::field_num( stmt, "NAME" )
        num4 = DB2::field_num( stmt, "WEIGHT" )
        
        num5 = DB2::field_num( stmt, "TEST" )
        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
        puts"Connection failed."
      end
    }
  end

end

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