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: Zulkigrel Tygorisar
Country: Russian Federation
Language: English (Spanish)
Genre: Science
Published (Last): 4 February 2006
Pages: 329
PDF File Size: 7.35 Mb
ePub File Size: 10.96 Mb
ISBN: 374-4-81330-392-2
Downloads: 12662
Price: Free* [*Free Regsitration Required]
Uploader: Sazilkree

Email required Address never made public. Leave a Reply Cancel reply Enter your comment here Hi Ajith, Could you pl. Sometimes I noticed there are indexing requests on deleted geference.

Thus, you may want to delete it. Infrastructure at your Service. Many of you must be using Samson to do your DQL queries. This query displays the number of failed logons in the docbase per user since 60 minutes.

Check its log file, it normally contains all these information already.

Documentum: some useful queries (DQL/IAPI)

It is useful for the IAPI command returning the index agent status see below. The indexing request remains in the queue for life.

Please also note that the default port is for the dsearch and for the index agent. December 12, at 12 h 57 min. Can you please let me know if there emf way to convert an ASCII file to pdf and file to Documentum so that a user and search on it. October 15, at 11 h 11 min. Any effort to remove it fails with this error: In order to use them, I recommend Qdman: April 27, at 10 h 36 min.


Brand new to Documentum. This one folder still has the old group and the new group in the permissions list.

EMC Community Network – DECN: DQL reference

In fact, it can happen if someone saved a document, then deleted it right after. It can be used to check if the regerence is working fine and if the indexing has refersnce performed correctly. Note that the parameter can still ne changed. Is it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute?

Be aware that it can take a while depending on the number of entries you have. November 29, at 9 h 51 min.

Sample DQLs – Ajith Prabhakar’s Weblog

These are sample queries which will select one or more attributes from an Object and illustrates different where clauses. It shows the version of the installer. In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below. December 12, at 12 h 39 min. This query flushes caches, it can be used when trying to install ADTS dars and fails due to version mismatch. You are commenting using your Facebook account. This Query returns the failed renditions. You are commenting using your WordPress.


As the indexing request, this one puts a PDF rendition request in the queue.

I am a total newbie at this and found your extremely useful blog with related matters and hope you can help. This query returns all documents present in the rendering queue.

So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue.

Sample DQLs

First, check if the file is deleted by running the IPAI: But how can I list folders and documents in the same way referece it is listing in Webtop folders are listed first in sorted order, then documents are listed in sorted order. The following queries concern the rendition component. If not, it will return 0 results for a document that you know does exist in the docbase.

There are many constraints on modifying an existing attribute Refer to DQL Manual for more information.