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

class TestIbmDb2 < Test::Unit::TestCase

  def test_157b
    assert_equal expected, capture {
      conn = DB2::connect(database, user, password)
      if conn
        sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed"
        stmt = DB2::prepare(conn, sql, {'cursor' => DB2::SCROLLABLE})
        result = DB2::execute(stmt)
      
        i=2
        while (row = DB2::fetch_assoc(stmt, i))
          printf("%-5d %-16s %-32s %10s\n", 
            row['ID'], row['NAME'], row['BREED'], row['WEIGHT'])
        
          i = i + 2
        end
      end
    }
  end

end

__END__
0     Pook             cat                                    3.20
5     Rickety Ride     goat                                   9.70
2     Smarty           horse                                350.00