DQL query to return all files in a Cabinet in Documentum?

Question

I want to retrieve all the files from a cabinet (called 'Wombat Insurance Co'). Currently I am using this DQL 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 0 100 '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!

I have also tried using the hint ENABLE(FETCH_ALL_RESULTS 0) but this still only returns a maximum of 100 results.

To clarify, my question is: how can I get all the files from a cabinet?

Answer 1

You have already accepted an answer which is using DFS.

Since your are playing with DFC, these information might help you.

DFS:

If you are using DFS, you have to aware about the number of concurrent sessions that you can consume with DFS. I think it is 100 or 150.

DFC:

Actually there is a limit that you can fetch via DFC (I'm not sure with DFS).

Go to your DFC application(webtop or da or anything) and check the dfc.properties file.

# Maximum number of results to retrieve by a query search.                      
# min value:  1, max value: 10000000
# 
dfc.search.max_results = 100

# Maximum number of results to retrieve per source by a query search.           
# min value:  1, max value: 10000000
# 
dfc.search.max_results_per_source = 400

dfc.properties.full or similar file is there and you can verify these values according to your system.

And I'm talking about the ContentServer side, not the client side dfc.properties file.

If you use ENABLE (RETURN_TOP) hint with DFC, there are 2 ways to fetch the results from the ContentServer.

1. Object based
2. Row based

You have to configure this by using the parameter return_top_results_row_based in the server.ini file.

All of these changes for the documentum server side, not for your DFC/DQL client.