Query on Dql queries
Comments
-
Are you trying to find folders that are not linked? If not, remove the folder() predicate in your search criterion:
Select r_object_id, object_name from dm_folder enable(RETURN_RANGE 50 100 'r_object_id ASC')
Also, its bad forum etiquette to repost the same question.
0 -
Thanks for reply..i tried it, but returns error saying A parser Error has occurred in vicinity.Executed query is same as you preferred.
Full Error message as [DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: Select r_object_id, object_name from dm_folder enable(RETURN_RANGE 50 100 'r_object_id ASC'"0 -
If you are running in Samson, then you should be able to run this in Documentum Administrator as well.
There are other utilities (e.g. dqMan, RePoint, etc) that works with CS 6.7. However, these utilities do not seem to work with newer 16.4 version, since dmcl is no longer supported.
0 -
Not sure what you are trying to do. If you are NOT doing this programmatically, why do you need to retrieve records based on Rownum? Why cant you just retrieve all of them, export them to xls file, and the retrieve the specific records you want based on row numbers.
0 -
I think the main problem is: attr/column "rownum" not availabe at DQL level...
AFAIK that is a dynamically added attr/column in the underlying RDBMS (Oracle?).
To have it available at DQL level you may do this:
1. Transform your intended DQL query to SQL adding that internal rownum attr/col as a result attr/column.
2. Define a view in your underlying RDBMS representing your query.
3. Register that view in Documentum (registered table)
4. Query the Documentum registered table applying filter criteria to now available attr/column "rownum"Hint:
You may not use name "rownum" but some other alias because that may be a reserved word?!0 -
I checked DQL documentation...
Hint "ENABLE(RETURN_RANGE...)" was not available in 6 and 6.5.
Finally in 6.7 DQL documentation this feature appears... maybe his Samson tool or his Content Server uses some too old ancient DFC ?
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 104 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax