Documentum 16.4 - Best and Fast way to export large data to CSV

sarma_kanapalle
sarma_kanapalle
in Documentum #1

Hi,

We have image data for 22 million records in Documentum.
Need to export values of 2 columns to a CSV file. The query looks like below.

SELECT object_name, r_object_id
FROM dm_document
WHERE folder('/GBSCaptivaAPV/MicroScan')
ENABLE
(UNCOMMITED_READ)

What is the best and fast way to export results of this query to a CSV file?
We have DqMan installed.

Appreciate your help!

Thank You.

Comments

  • DCTM_Guru
    DCTM_Guru
    #2

    The fastest way would to export the desired columns directly from database client. Run your DQL in DA and check "show sql" checkbox. This will give you want you need to run your query in your SQL client. Then use whatever export option is provided by your SQL client.

  • sarma_kanapalle
    sarma_kanapalle
    #3

    Thank you @DCTM_Guru Will try this.

Categories