Tag archives for DQL

Documentum : freeze, checkin, checkout, lock,…
Hello, Just a post concerning the freeze, unfreeze mechanism of documentum which allows to mark an object and, optionally, its components (if the object is a virtual document), as unchangeable. There is also the lock/unlock mechanism which places a database lock on an object. FREEZE DOCUMENT The content server modifies these following attributes of the object when freezing an object : • r_immutable_flag to ...more»
Documentum : BUG in DQL Date Functions When Together Use Of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD
Hello, Just a post concerning the BUG of use of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD together. To illustrate this problem, for example, we would like to list the documents (r_object_id) modified during the last year: ==> Error occured during query execution :error: "A Parser Error (syntax error) has occurred in the vicinity of: SELECT r_object_id FROM dm_document WHERE r_modify_date >= "   ==> Error occured ...more»
Documentum : DQL performance testing tool DQLPerformanceTest
Hello, I would like present a useful good tool DQLPerformanceTest v1.1 provided by DELL EMC and created by Krzysztof Jurkowski. The first part (PRESENTATION) of this post has been copied/pasted from EMC website ( In the second part (EXAMPLE OF USE), I would expose a full example of tool's use and interpretation of generated results.   PART I : PRESENTATION Description DQLPerformanceTest is a java ...more»
Documentum : Execution of DQL script via IDQL32, API script via IAPI32
Hello, Just a post concerning the execution of DQL script via IDQL32, and API script via IAPI32.   DQL script via IDQL32 Here an example on exportation of unused ACLs in CSV file: Creation of DQL script : script_dql_export_acl_not_used.dql in order to export the unused ACLs in a CSV file named script_dql_export_acl_not_used_result.csv: Execution of script on content server via idql32 Tools. This script requires several parameters. Note: ...more»
Copyright ® 2012 Hüseyin Özveren. No reproduction, even partial, can be used from this site and all its contents including text, documents, images, etc.. without the express permission of the author.