Tag archives for DQL

Documentum : freeze, checkin, checkout, lock,…

14
Jun

posted by Huseyin OZVEREN               filed under API DCTM, DEVELOPMENT, Documentum, DQL DCTM, TOOLS DCTM

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»

Tags: API, checkin, checkout, Documentum, DQL, freeze, lock, unlock

Comments (0)

Documentum : BUG in DQL Date Functions When Together Use Of DATEFLOOR, DATEDIFF, DATETOSTRING and DATEADD

14
Feb

posted by Huseyin OZVEREN               filed under DEVELOPMENT, Documentum, DQL DCTM

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»

Tags: BUG, date, DATEADD, DATEDIFF, DATEFLOOR, DATETOSTRING, Documentum, DQL, functions, use

Comments (0)

Documentum : DQL performance testing tool DQLPerformanceTest

8
Feb

posted by Huseyin OZVEREN               filed under Documentum, DQL DCTM, Tools

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»

Tags: Documentum, DQL, performance, testing, tool

Comments (0)

Documentum : Execution of DQL script via IDQL32, API script via IAPI32

6
Feb

posted by Huseyin OZVEREN               filed under API DCTM, DFC DCTM, Documentum

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»

Tags: API, Documentum, DQL, Execution, IAPI32, IDQL32, script

Comments (0)

• RSS Feeds

  • Post Entries Feeds
  • Post Comments Feeds

• Tags

  apache API application BlockingQueue client cloud Command Configuration content Crypto Cryptology database deployment DEVELOPMENT Documentum DQL ecm Encryption example Execution extjs File Files GAE generate generation gwt Hibernate java job library method object Presentation Queue script sencha server Service spring tomcat tool Validation web xml

•  Categories

   Categories Select Category Cloud  (1) Cryptology  (15) Database  (9) DEVELOPMENT  (193)    C#  (5)    Java  (128)    Libray  (15)    Tools  (37) Documentum  (64)    API DCTM  (12)    DFC DCTM  (13)    DQL DCTM  (17)    TOOLS DCTM  (18) ECLISPE  (9) ECM  (18) GAE  (12) Google  (12) GWT  (13) Hibernate  (7) HTML5  (1) php  (1) powershell  (3) Sencha  (14) SharePoint  (1) Spring  (23) Unix  (5) WEB  (37)

• Recent Posts

  • Protected: JAVA : Create a connection to SHAREPOINT site
  • Protected: Java 8/Documentum : use of future, callable tasks
  • Protected: Documentum/java : GET_LAST_SQL method
  • Protected: Java : java decompiler
  • Protected: Java : log4j : Documentum + some articles on log4shell topic
  • Protected: JAVA : Track Oracle Java Versions (powershell solution)
  • Protected: Documentum : WS DFS : SOAP requests / SOAP responses – SOAPUI
  • Protected: Web service : SOAP : Proxy : ProxyTrace, TCPTrace
  • Protected: Java : Generation of Java POJO classes from XSD files with jaxb-xjc
  • Protected: Java : Generation of a XSD from Java POJO classes with jaxb-xjc
  • Protected: Documentum : use of dynamic group dm_read_all_dynamic
  • Protected: Documentum : BOF – SBO (Service based Business Object) – SSLHandshakeException – SunCertPathBuilderException – Truststore, Keystore
• Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
  To find out more, including how to control cookies, see here: Cookie Policy