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: Zugul Zulkinris
Country: Paraguay
Language: English (Spanish)
Genre: Medical
Published (Last): 4 October 2012
Pages: 455
PDF File Size: 11.97 Mb
ePub File Size: 1.41 Mb
ISBN: 257-3-12561-510-2
Downloads: 73459
Price: Free* [*Free Regsitration Required]
Uploader: Doutaxe

Click here to download this study note PDF. It regroups the rendition queue check and the way to manually ask a rendition through IAPI.

Sample DQLs – Ajith Prabhakar’s Weblog

It is useful for the IAPI command returning the index agent status see below. Any suggestions would be helpful. Please log in using one of these methods to post your comment: This statement purges the audit trail queue by deleting all logon failure entries. This one folder still has the old group and the new group in the permissions list. Can you please let me know if there is way to convert an ASCII file to pdf and file to Documentum so that a user and search on it. July 31, at 8 h 21 min.


You are commenting using your WordPress. That means all document waiting for rendition.

The following queries concern the rendition component. This query returns all documents present in the rendering queue. November 29, at 9 h 51 min.

Note that you have to replace the Indey Agent information in the first line by your Index Agent.

Sample DQLs

Infrastructure at your Service. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses.

Index Agent Info select fti. Notify me of new comments via email.

Documentum: some useful queries (DQL/IAPI)

If no rendition is present for the given document, it returns nothing. October 15, at 11 h 11 min. Check its log file, it normally contains all these information already.

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

In Samson, if you forgot to terminate the query with a semicolon ; you will get a refeerence like shown below. 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.

Hi Ajith Is emv possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute? So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue.


April 27, at 10 h 36 min. This one simply puts an indexing request in the queue. Hi Ajith, I have the following query to list all documents and folders in a cabinet. This means that if a rendition request failed 3 times in a row and succeed the last time, cql will be 3 rows in the failed queue, but the rendition did succeed. In order to use them, I recommend Qdman: This rederence 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. In fact, it can happen vql someone saved a document, then deleted it right after. Sometimes I noticed there are indexing requests on deleted documents. November 11, at 8 h 18 min. These examples are meant to give you a head-start on the basic DQL syntax.

Need a DQL query to find the total number of documents present and total size utilized in docbase.