Book Image

Documentum Content Management Foundations: EMC Proven Professional Certification Exam E20-120 Study Guide

By : Pawan Kumar
Book Image

Documentum Content Management Foundations: EMC Proven Professional Certification Exam E20-120 Study Guide

By: Pawan Kumar

Overview of this book

This is a complete study guide including study material and practice questions to prepare for the EMC Proven Professional certification Exam E20-120. It can also serve Documentum beginners and practitioners as a handy guide and quick reference to the technical fundamentals that is fully up to date for Documentum 5.3. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.EMC Documentum is a leading enterprise content management technology platform that helps enterprises to streamline the capture, processing, and distribution of business information including documents, records, e-mails, web content, images, reports, and digital assets. It can also automate entire business processes in accordance with business rules. EMC Proven Professional is an exam-based certification program, which introduced a new EMC Proven Content Management Application Developer (EMCAD) track in early 2007. The first exam in this track is Content Management Foundations (CMF) Associate-level Exam, with exam code E20-120, which tests knowledge about technical fundamentals of Documentum. This book is a study guide to help you prepare for this exam with hundreds of practice questions and an efficient exam-preparation strategy.
Table of Contents (23 chapters)
Documentum Content Management Foundations
Credits
About the Author
Acknowledgement
About the Reviewers
Preface

Help—Some DQL Queries


While DAB and Webtop can be used to interact with objects and lifecycles, the following queries can be used to obtain specific information directly.

The following DQL query identifies the lifecycle ID, current state, and the resume state (meaningful only if the current state is an exception state) for a document. Note, however, that all of this information is system data (internal) and not user-friendly. This information neither names the policy nor the states; they are all numbers.

SELECT r_policy_id, r_current_state, r_resume_state
FROM dm_document
WHERE object_name like 'MyDocument%'

The user-friendly information can be obtained from the lifecycle separately or by joining with the above query. The following query lists information about the states in a lifecycle named Resume:

SELECT object_name, state_name, state_description, state_class
FROM dm_policy
WHERE object_name = 'Resume'

Note that the state properties queried above are repeating properties and list all the...