Output of a DQL to be written into a document using DFC

Raina

Hi All,

I am running a DQL which gives me result set ..

I wanted to write the output into a file and save it in the repository.

Kindly help me out.

Thanks

Raina

Find more posts tagged with

Comments

lastnitescurry

java write file

http://www.google.ie/search?q=java+write+file&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a

dfc get query results

http://www.google.ie/search?q=dfc+get+query+results&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a

Raina

Hi,

IDfClientX clientx =new DfClientX();IDfQuery query = clientx.getQuery();

String qry =

"selectr_object_id,object_name,a_last_invocation,a_current_status,is_inactive,title,a_last_completion,a_next_invocation,target_server,expiration_date from dm_job where is_inactive='0'";

query.setDQL(qry);IDfCollection col = query.execute(ssn, IDfQuery.DF_READ_QUERY);

This gives a collection, how to make this collection write into a file and save it in a particular repository.

IDfSysObject object = (IDfSysObject)ssn.newObject(

"dm_document");

object.setTitle("Title");object.setObjectName(

"Report");object.setContentType(

"crtext");

How do i continue from here?

dnvhariprasad

If you have Documentum Reporting Services and is on 6.5 version of content server, you can create a report and schedule it to run automatically which can also save in repository.

There are many methods which comes with documentum which stores their job report in documentum itself. export the method files and decompile to see the logic.