class TestIbmDb2 < Test::Unit::TestCase

  def test_157a
    assert_expectf do
      assert_throws :'Fetch Failure' do
        conn = DB2::connect db,username,password
        if conn
          sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed"
          result = DB2::exec conn, sql
        
          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

end

__END__