Book Image

Web Content Management with Documentum

Book Image

Web Content Management with Documentum

Overview of this book

One of the world leaders in Enterprise Content Management, the EMC Documentum family of applications helps you manage all types of content across multiple departments within a single repository. With the Web Content Management suite of applications, you can efficiently manage content and underlying processes for your Web properties, and ensures that they are responsive to business needs. To fully realize the power of this system can seem daunting, but this book will help you achieve that. With easy to follow examples, this book will take you the simplest and most straightforward route to success. Along the way, you will learn insights that only a seasoned professional would know. Packed with practical examples, you will get hands-on with the powerful features of Documentum to grow your skills and confidence. You will see tips and tricks to handle complexities of the system, and avoid the common errors that waste your time. From installing and getting started with Documentum, you will see how to design and develop Documentum applications, before rounding off with deployment.
Table of Contents (33 chapters)
Web Content Management with Documentum
Credits
About the Author
Acknowledgements
Preface
Frequently Asked Questions and Answers

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...