Friday, November 05, 2010

Running IDQL in Content Server

WINDOWS
idql32 docbasename -Uusername -Ppassword -Rfilename.dql > abc_output.txt
UNIX
Location.
$DOCUMENTUM_HOME/product/6.5/bin
e.g. /opt/apps/Documentum/product/6.5/bin
./idql docbasename -Uusername -Ppassword -Rfilename.dql > abc_output.txt

where filename.dql contains your DQL query1) create filename.dql file.2) write your DQL query ex: SELECT r_object_id,object_name FROM dm_document
go
3)save document
4) use the idql command which is given above