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: Tojakree Kagaramar
Country: Martinique
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 8 January 2016
Pages: 159
PDF File Size: 19.42 Mb
ePub File Size: 18.25 Mb
ISBN: 317-5-13222-852-6
Downloads: 69079
Price: Free* [*Free Regsitration Required]
Uploader: Gagore

The following queries concern the rendition component. This means that if a rendition rederence 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. December 12, at 12 h 39 min. You are commenting using your WordPress. I tried to reassign a group to a new group and the job worked except that it did not update one folder.

Documentum: some useful queries (DQL/IAPI)

In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below. Click here to download this study note PDF.


You can create a PDF rendition of a Acsii file, for that you need a PDF converter plugin, for searching within the contents of a file you should have full text search enabled on that content server. This query will return the number of items waiting to be indexed since 15 minutes.

It is useful for the IAPI command returning the index agent status see below. In order to use them, I recommend Qdman: Note that the parameter can still ne changed.

Please also note that the default port is for the dsearch and for the index agent. Index Agent Info select fti. As the indexing request, this one puts a PDF rendition request in the queue. Referrnce Ajith, I have the following query to list all documents and folders in a cabinet. Check its log file, it normally contains all these information already.

EMC Community Network – DECN: DQL reference

The indexing request remains in the queue for life. Sometimes I noticed there are indexing requests on deleted documents. You are commenting using your Twitter account. It can be useful when scripting or in DFC programs. Be aware that it can take a while depending on the number of entries you have.


Sample DQLs

Need a DQL query to find the total number of documents present and total size utilized in docbase. You are commenting using your Facebook account. April 27, at 10 h 36 min.

There are many constraints on modifying an existing attribute Refer to DQL Manual for more information. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses.

Brand new to Documentum. The workaround to continue with this refersnce is typing go and pressing Enter again.

Hi Ajith, Could you pl. It shows the version of the installer.

It can be used to check if the dsearch is working fine and if the indexing has been performed correctly. The parameter 60 can be changed. Many of you must be using Samson to do your Refreence queries. This one simply puts an indexing request in the queue.