class TestIbmDb2 < Test::Unit::TestCase

  def test_157b
    assert_expect {
      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