
Tag archives for DQL
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»
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»
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 (https://community.emc.com/docs/DOC-32505). 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»
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»
