2.7 DQL

DQL is short for Document Query Language and uses syntax that is a superset of ANSI-standard SQL (Structured Query Language). For those familiar with SQL, DQL can be simply thought of as a Documentum wrapper over SQL.

DQL is used to perform the following operations in a Docbase:

• Query, update, and delete objects in Docbase

• Create new objects in Docbase

• Search content in Docbase

• Query Registered tables

Example of a simple DQL query:

select r_object_id from dm_document where object_name = 'SampleDocument.xml'

The above query selects the unique Object ID of an object of type dm_document whose name is SampleDocument.xml

DQL queries can be fired from within:

• Documentum Administrator (a Documentum web client)

• DFC (Documentum Foundation Classes)

• IDQL utility

IDQL is an interactive utility/tool installed along with the Content Server and allows us to execute DQL queries against a Docbase. Figure 2.8 shows how a sample DQL query is fired using the IDQL utility.

Note

Documentum 5.3 Update

Documentum...