class TestIbmDb2 < Test::Unit::TestCase

  def test_157a
    assert_expectf {
      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__
PHP Warning:  DB2::fetch_assoc(): Fetch Failure in %s on line %d