Another item not explained very well.  Let's see if I can do better than others have done?   Applies to Windows servers.

Objective:  run a query or set of DQL commands contained in a file and have results from query or DQL commands written to a file.  

1. prepare a file containing your DQL commands...could be something like:

select r_object_id from dm_document;

go  

2. save these DQL commands to a text file. In our case I'll call it steveDQL.txt.

3. access server and locate idql32.exe.  This will probably be in a path similar to:  C:\Documentum\product\6.0\bin

4. move text file created in Step 2 above (steveDQL.txt) to the same directory as idql32.exe.

4. open  a DOS command prompt and navigate to that location where idql32.exe is located

5.  run this command:

idql32 dev -Uuser -Ppass -RsteveDQL.txt > c:\dqlresults.txt

Where:

idql32: is command to run idql32.exe

dev: repository name

user:  name of user

pass: password

steveDQL.txt: name of input file that contains DQL commands

>: this symbol tells it to output to a file

c:\dqlresults.txt:: arbitrary filename and path of file to write results of DQL command to 

 The file dqlresults.txt might contain:

EMC Documentum idql - Interactive document query interface

(c) Copyright EMC Corp., 1992 - 2007

All rights reserved.

Client Library Release 6.0.0.114SP1

Connecting to Server using docbase dev

Connected to Documentum Server running Release 6.0.0.116 SP1 Win32.Oracle

1> 2> r_object_id     

----------------

0900084680000992

0900084680000993

0900084680000994

0900084680000995

0900084680000996

0900084680000997 

DOT DOT DOT - CONTINUED

0900084680002872

0900084680002873

(1388582 rows affected)

1>