The language used to query Documentum which is a content management
system used to create, manage, deliver, and archive all types of content from text documents and spreadsheets to digital images, HTML, and XML components.
Contents
• Define DQL
• Behind the scenes
• Describe a SELECT statement
• Describe how search conditions are specified in a WHERE clause
• Using DQL to search a specific cabinet/folder location
• Describe the DQL REGISTER statement
DQL (Documentum Query Language) is a query language which allows you to do very complex queries involving:
1. Property searches
2. Searches for words and phrases within documents
3. Other specialized searching capabilities added for document and content management
DQL uses syntax that is a superset of ANSI-standard SQL (Structured Query Language)
• In fact, part of your DQL statements are translated automatically into SQL before being executed by the eContent Server
Behind the Scenes
• A DQL query is sent to the eContent Server using one of four API methods
readquery, execquery, query, or cachequery
• A DQL engine on eContent Server generates
– SQL queries for the RDBMS
– Verity queries for the full-text search engine
The results of the query are stored on the server in a non-persistent collection
object. Typically, a Documentum client will automatically present the results
of the query to the user in some useful way.
Alternatively, a Developer may want to use the resulting collection object or
manipulate the results programmatically.
Basic Select Statement
Select (list the properties you want returned)
From (list the type of objects you want searched)
Using WHERE clause
Allows the search to be narrowed by imposing search conditions on your
Query
select [all | distinct] value [as name] {, value [as name] } from source_list [(all)]
...
[where qualification ]
Eg :
SELECT object_name, title FROM dm_document WHERE FOLDER (ID(’0b9af3ce800001ff’)) AND title LIKE ’%SOP%’
Searching folders and cabinets
The scope of the search can be specified as folder and cabinet in the where clause to provide a way to search the cabinet/folder hierarchy.
Eg : select object_name from dm_document where folder(‘/Sales’)
REGISTER statement
• Registers an RDBMS table so the eContent Server can “see" it
• Allows access to data in an existing RDBMS table that may be
– created to support additional application data
– part of another application
– owned by someone else
• Does not verify that the table or its columns exist
• All columns in a table need not be registered
• Creates a dm_registered object in the System cabinet which
provides a description of the table and user access to it
REGISTER permissions
• Only the Docbase owner with a SUPERUSER privilege can register a table from
within Documentum.
• To register a table, you must have at least READ permission on the table (through the
RDBMS grant command).
• The eContent Server account (installation owner) needs the appropriate RDBMS
privileges on the table to perform different operations on rows in the table.
» left by Chris from TX (4 years 128 days ago.)
I am working in Documetum. This article gives a brief description about DQL.It is good. Respond to this comment
» left by John from Bangalore (4 years 128 days ago.)
simple and understandable Respond to this comment
» left by Varghese from Cochin (4 years 128 days ago.)
Very Good introduction Respond to this comment
» left by Lora from UK (4 years 72 days ago.)
I was in search to know what is DQL. It gives a brief idea. It is very helpful to know what is it. Please include more examples. Respond to this comment
» left by Norman S. Wilkins from Indianapolis, IN (4 years 20 days ago.)
Good stuff...wish there were more. Respond to this comment
» left by Brandon from Minnesota (4 years 19 days ago.)
The article helps to get you headed the in the right direction. Especially when you are just starting to create DQL queries.
Thanks Respond to this comment
» left by Sudeep Ghatak from Frederick MD (3 years 267 days ago.)
The document is good to start with. It would be nice if the document also has links to some websites where there is more about DQL Respond to this comment
» left by Srinivasan from Chennai, India (3 years 128 days ago.)
This is good. Dql keyword like documet, user, folder and many are there, if you provide these kind of information will help new guys.
» left by Abhinesh from Bangalore (3 years 100 days ago.)
Good one but I want to know how to handle single quote in DQL as this gives an error. Any one who can provide help in this. Respond to this comment
» left by bhaskar from gurgaon (2 years 122 days ago.)
how to write the quries using DQL?i want clear picture with tables? Respond to this comment
» left by umesh from bangalore (2 years 79 days ago.)
Hi, it is very good for beginners ,
» left by rajiv from USA (2 years 73 days ago.)
To write a clear query you have to use the DQL editor which can be found in the documentum administrator under Docbase management. Respond to this comment
» left by Will from Chile (1 year 233 days ago.)
Hi, This is good, but i need more information, where i can get DQL Manual? Respond to this comment
» left by S.R.Karthik from Chennai (1 year 19 days ago.)
The explanation was really awesome... If there would be more articles regarding documentum then it would be well and good.... Anyway thanks for the good startup.....
Disclaimer: All information on this site is provided for informational purposes only! By no means is any
information presented herein intended to substitute for the advice provided to you by any health care or other professional
or organization.
