class TestIbmDb2 < Test::Unit::TestCase

  def test_157
    assert_expect {
      conn = DB2::connect db,username,password
      if conn
        sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed"
        result = DB2::exec conn, sql, {'cursor' => DB2::SCROLLABLE}
        i=2
        while (row = DB2::fetch_assoc(result, 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