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

class TestIbmDb2 < Test::Unit::TestCase

  def test_041
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      
      if conn
        stmt = DB2::exec( conn, "select * from animals order by breed" )
      
        i = 0
      
        while( cols = DB2::fetch_{ stmt } )
          foreach (cols as col)
            puts "#{col} "
          end
          puts "\n"
          i++
        end
      
        puts"\nNumber of rows: ".i
      else
        puts"Connection failed."
      end
    }
  end

end

__END__
4 budgerigar Gizmo            0.20 
0 cat Pook             3.20 
1 dog Peaches          12.30 
5 goat Rickety Ride     9.70 
3 gold fish Bubbles          0.10 
2 horse Smarty           350.00 
6 llama Sweater          150.00 

Number of rows: 7