I had a problem with running a DQL to capture a large set of results in a comma separated file (CSV) format. Documentum Repoint offers this function but fails to display the full set of large results. I decided to program my own small Java tool to complete this requirement.
I find it a useful tool to compare results between repositories when migrating data before and after snapshots.
The Java process handles the memory itself so you shouldn't run out of memory generating the CSV results.
Requirements
JRE (I tested against JRE 1.6.0_27)
Documentum DFC (I tested against DFC 6.7SP1)
Process Inputs
A DQL Text File of the following layout
line 1: SELECT
line 2: columns to be selected (This line is also used as the header line of the output CSV file)
line 3: FROM <object type> <WHERE predicate...>
line 4: ORDER BY <column(s)>
Take the attached Java class (in aait.jar) and the example DQL text file (DQLtoRun.dql) and run it as follows:
On UNIX/Linux:
java -Xms256M -Xmx1024M -classpath "./lib/aait.jar:./lib/dfc/dfc.jar:./lib/log4j.jar:%CLASSPATH%" com.aait.utils.GenerateCSVFromDQL -docbase $1 -username $2 -password $3 -inputdql ./dql/DQLtoRun.dql -outputcsv ./dql/csv/OutputCSV.csv 2>&1 > ./logs/GenerateCSVFromDQL_$1.log
On Windows:
java -Xms256M -Xmx1024M -classpath ".\lib\aait.jar;.\lib\dfc\dfc.jar;.\lib\log4j.jar;%CLASSPATH%" com.aait.utils.GenerateCSVFromDQL -docbase %1 -username %2 -password %3 -inputdql .\dql\DQLtoRun.dql -outputcsv .\dql\csv/OutputCSV.csv 2>&1 > .\logs\GenerateCSVFromDQL_%1.log
I hope you find this simple tool useful. Any feedback is welcome.