title: DQL query to return all files in a Cabinet in Documentum?
body: <p>I want to retrieve all the files from a cabinet (called 'Wombat Insurance Co'). Currently I am using this DQL query:</p>
  
  <pre><code>select r_object_id, object_name from dm_document(all) 
  where folder('/Wombat Insurance Co', descend);
  </code></pre>
  
  <p>This is ok except it only returns a maximum of 100 results. If there are 5000 files in the cabinet I want to get all 5000 results. Is there a way to use pagination to get all the results? </p>
  
  <p>I have tried this query:</p>
  
  <pre><code>select r_object_id, object_name from dm_document(all) 
  where folder('/Wombat Insurance Co', descend) 
  ENABLE (RETURN_RANGE 0 100 'r_object_id DESC');
  </code></pre>
  
  <p>with the intention of getting results in 100 file increments, but this query gives me an error when I try to execute it. The error says this:</p>
  
  <pre><code>com.emc.documentum.fs.services.core.CoreServiceException: "QUERY" action failed.
  
  java.lang.Exception: [DM_QUERY2_E_UNRECOGNIZED_HINT]error:  
  "RETURN_RANGE is an unknown hint or is being used incorrectly."
  </code></pre>
  
  <p>I think I am using the RETURN_RANGE hint correctly, but maybe I'm not. Any help would be appreciated!</p>
  
  <p>I have also tried using the hint <code>ENABLE(FETCH_ALL_RESULTS 0)</code> but this still only returns a maximum of 100 results.</p>
  
  <p>To clarify, my question is: how can I get <em>all</em> the files from a cabinet?</p>