Tag archives for DQL

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)

Documentum : Repeating and Single Value Attributes in Database, Tables, Views, Aspects, i_position

21
Jan

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

Hello, This post is relating to repeating and single attributes in underlying database. Documentum objects support 2 types of attributes: Single Value Attributes Single Value properties are properties that can hold a single value at a time like the attributes r_object_id, object_name,...etc. Repeating Attributes Repeating Attributes are properties that can hold multiple values like the attributes Keywords, i_folder_id, r_aspect_name...etc.   TABLES All objects/properties/attributes are saved in underlying database. ...more»

Tags: aspect, database, Documentum, DQL, position, Repeated, Repeating, Single Value Attributes, Table, view

Comments (0)

• RSS Feeds

  • Post Entries Feeds
  • Post Comments Feeds

• Tags

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

•  Categories

   Categories Select Category Cloud  (1) Cryptology  (15) Database  (8) DEVELOPMENT  (176)    C#  (3)    Java  (118)    Libray  (11)    Tools  (32) Documentum  (59)    API DCTM  (12)    DFC DCTM  (13)    DQL DCTM  (15)    TOOLS DCTM  (17) ECLISPE  (9) ECM  (18) GAE  (12) Google  (12) GWT  (13) Hibernate  (7) HTML5  (1) php  (1) Sencha  (14) Spring  (23) Unix  (5) WEB  (35)

•  Archives

   Archives Select Month July 2018  (2) June 2018  (3) April 2018  (1) March 2018  (1) February 2018  (1) December 2017  (2) November 2017  (6) October 2017  (1) August 2017  (4) May 2017  (1) April 2017  (2) March 2017  (13) February 2017  (22) January 2017  (14) December 2016  (5) November 2016  (7) October 2016  (4) September 2016  (4) August 2016  (1) October 2014  (1) July 2014  (1) May 2014  (2) April 2014  (2) March 2014  (1) February 2014  (5) December 2013  (1) September 2013  (1) August 2013  (2) July 2013  (2) March 2013  (1) February 2013  (2) January 2013  (2) December 2012  (3) November 2012  (3) October 2012  (3) September 2012  (8) August 2012  (11) July 2012  (12) June 2012  (22) May 2012  (17) April 2012  (16)

• Recent Posts

  • Java : Web Service : Tracing XML requests/responses with JAX-WS
  • Documentum : Execution CMD/PowerShell Via Job/Method
  • SAMBA JCIFS : Open Source library for CIFS/SMB networking
  • Apache : Commons Configuration
  • Documentum : Audit trail entries dm_audittrail / SessionConfig / application_code
  • Documentum : Deleting of audit trail entries dm_audittrail
  • Documentum : Principal-Mode Authentication : Use of IDfPrincipalSupport
  • Java : Generation Of Proxies for CXF, AXIS web services via ANT Script (WSDLToJava)
  • Documentum : Relation MAIL With External Internal Attachments (dm_relation, content_attr_name, content_attr_value…)
  • Documentum : DataSource Configuration (DS)
  • CSharp/C# : Custom Logging Service With NLog
  • CSharp/C# : Get the source folder path of CSharp class

• JavaBlog.fr / Java.lu NewsLetter

  Email