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

class TestIbmDb2 < Test::Unit::TestCase

  def test_032
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      if conn
        stmt = DB2::exec( conn, "SELECT id, breed, name, weight FROM animals WHERE id = 6" )
        
        while (DB2::fetch_row(stmt) == TRUE)
          id = DB2::result( stmt, "ID" )
          var_dump( id )
          breed = DB2::result( stmt, "BREED" )
          var_dump( breed )
          name = DB2::result( stmt, "NAME" )
          var_dump( name )
          weight = DB2::result( stmt, "WEIGHT" )
          var_dump( weight )
        end
        DB2::close(conn)
      else
        puts"Connection failed.\n"
      end
    }
  end

end

__END__
int(6)
string(5) "llama"
string(16) "Sweater         "
string(6) "150.00"