DQL query to return all files in a Cabinet?

FirstName

I want to retrieve all the files from a cabinet. Currently I am using this query:

select r_object_id, object_name from dm_document(all) where folder('/Wombat Insurance Co', descend);

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?

I have tried this query:

select r_object_id, object_name from dm_document(all) where folder('/Wombat Insurance Co', descend) ENABLE (RETURN_RANGE "+start+" "+end+" 50 'r_object_id DESC');

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:

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."

I think I am using the RETURN_RANGE hint correctly, but maybe I'm not. Any help would be appreciated!

FirstName

Aha, I've figured it out. Using DFS with Java (an abstraction layer on top of DFC) you can set the starting index for query results:

String

where folder

query

query

queryEx

queryEx

You can just increment the currentIndex variable to get all results.