These examples are meant to give you a head-start on the basic DQL syntax. For more information on DQL, please refer to Content Server DQL Reference guide. EMC® Documentum® Content Server Version DQL Reference EMC Corporation Corporate Headquarters: Hopkinton, MA This guide is the reference manual for the EMC Documentum object hierarchy. to EMC Documentum Content Server DQL Reference, EMC Documentum.

Author: Brajin Tygosida
Country: Saint Lucia
Language: English (Spanish)
Genre: Automotive
Published (Last): 27 October 2007
Pages: 418
PDF File Size: 2.11 Mb
ePub File Size: 6.79 Mb
ISBN: 855-5-47953-591-4
Downloads: 78260
Price: Free* [*Free Regsitration Required]
Uploader: Mozshura

Notify me of new comments via email. In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below.

Documentum: some useful queries (DQL/IAPI) – Blog dbi services

There are many constraints on modifying an existing attribute Refer to DQL Manual for more information. Note that the parameter can still ne changed. Be aware that it can take a while depending on the number of entries you have. Hi Ajith Is it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute? Please log in using one of these methods to post your comment: First, check if the file is deleted by running the IPAI: December 12, at 12 h 57 min.


Note that you have to replace the Indey Referenc information in the first line by your Index Agent. November 29, at 9 h 51 min.

Email required Address never made public. Click here to download this study note PDF. Index Agent Info select fti. These are sample queries which will select one or more attributes from dmc Object and illustrates different where clauses.

This query flushes ec, it can be used when trying to install ADTS dars and fails due to version mismatch. This query displays the number of failed logons in the docbase per user since 60 minutes. You can get these information thanks to the DQL query above.

Sample DQLs – Ajith Prabhakar’s Weblog

Check its log file, it normally contains all these information already. April 21, at 9 h 03 min. This Query returns the failed renditions. Need a DQL query to find the total number of documents present and total size utilized in docbase.

Documentum: some useful queries (DQL/IAPI)

This one folder still has the old group and the new group in the permissions list. July 31, at 8 h 21 min. Any suggestions would be helpful. This means that if a rendition request failed 3 times in a row and succeed the last time, there will be 3 rows in the failed queue, but the rendition did succeed. In fact, it can happen if someone referenve a document, then deleted it right after.


The workaround to continue with this query is typing go and pressing Enter again. This statement purges the audit trail queue by deleting all logon failure entries. Infrastructure at your Service.

This one simply puts an indexing request in the queue. So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue. This will return refdrence id and name of all the objects that was created between today and November 11, at 8 h 18 min. November 23, at 9 h 22 min.

Sample DQLs

Hi Ajith, Could you pl. These examples are meant to give you a head-start on the basic DQL syntax. Please also note that the default port is for the dsearch and for the index agent.