26.1 DQL

For those familiar with SQL (Structured Query Language), DQL is a similar querying language in Documentum.

26.1.1 Uses of DQL

DQL is used for the following purposes:

• Creating new objects in the Docbase

• Retrieving objects from the Docbase

• Updating objects in the Docbase

• Deleting objects from the Docbase

• Accessing registered tables

• Searching content in the Docbase

26.1.2 Command Tools

DQL queries can be executed via the following means:

• The IDQL utility

• Web clients such as Documentum Administrator or Web Publisher

IDQL is an interactive utility for running DQL queries against a Docbase. IDQL is available once you install Content Server and the executable idql32.exe can be found on Windows machines at the following location:

%DM_HOME%\bin, e.g. C:\Documentum\product\5.2\bin

You can invoke the executable directly from the command prompt as shown in figure 26.2 or you can click on the IDQL button shown in the Documentum Server Manager window (refer to figure 26.3). In both scenarios, you will...