Replacing DMCL call with DFC

I am trying to replace all DCML calls to DFC in C++ code.

I have following code in C++ module but it is failing.. please guide me to resolve the issue

IDfClientXPtr pClientX(__uuidof(DfClientX));
IDfCollectionPtr col; //Collection for the result
IDfQueryPtr q = pClientX->getQuery(); //Create query object

IDfClientPtr pClient = pClientX->getLocalClient();

//Initialize the session
pSession = pClient->findSession((LPCSTR)sessionID);

_bstr_t queryString = (_bstr_t)getCmd;

q->setDQL(queryString); //Give it the query
q->setBatchSize(0);

col = q->execute(pSession, DFCLib::IDfQuery_DF_QUERY);

_bstr_t query = (_bstr_t)getCmd;

IDfIdPtr idPtr = pSession->getIdByQualification(query);

//Set the object Id to the structure
objId = (StringT)(LPSTR)idPtr->getId();

Where getCmd=

readquery,s0,select all r_object_id, object_name, fsb_model from fsb_component(all) where object_name like '<FMFileName>%' and r_lock_owner=USER

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

aflowers001

If the query had the readquery,s0 at the start then it will fail. That is an API style of executing a query.

Try setting getCmd to return just the actual DQL query as per

select all r_object_id, object_name, fsb_model from fsb_component(all) where object_name like '<FMFileName>%' and r_lock_owner=USER

All comments

amit_kulkarni11

Trying to replace dmAPIGet() dmcl function.

aflowers001

In what way is it failing? Does it fail to compile or fail to execute?

amit_kulkarni11

It is failing at run time, while I try to execute the query.

Internally when i tried to debug it is failing at raw_execute(...)

amit_kulkarni11

I tried finding out the solution on net and EMC site, but did not get any C++ responce..

aflowers001

If the query had the readquery,s0 at the start then it will fail. That is an API style of executing a query.

Try setting getCmd to return just the actual DQL query as per

select all r_object_id, object_name, fsb_model from fsb_component(all) where object_name like '<FMFileName>%' and r_lock_owner=USER

amit_kulkarni11

Thanks Andy,

for further processing i want to get the object ID of this specific file which I have used in select query.

so is the following code correct for getting the object ID?

CString getCmd(100); //method passed to dmAPIGet

IDfSessionPtr pSession;

StringT objId;

.....

....

//Get the object Id of the file using the filename
getCmd = "dm_sysobject where object_name like '";
getCmd += "21-00-00-802.STD%";
getCmd += "'";

_bstr_t query = (_bstr_t)getCmd;

IDfIdPtr idPtr = pSession->getIdByQualification(query);

// F_ApiAlert((StringT)"After get Id", FF_ALERT_CONTINUE_NOTE);
//Set the object Id to the structure
objId = (StringT)(LPSTR)idPtr->getId();

return ( objId);

aflowers001

You are getting the object Id as a result in the query so you just need to loop over the returned collection.

Now I've never used C++ with Documentum, jusat VB via the COM interop, but here's a quick pseudo code outline

IDfQuery qry = new query

qry.setDQL(dql to execute);

IDfCollection coll = qry.execute( ... );

while(coll.next())

{

IDfId id = coll.getId("r_object_id"); // this will return the object id

String objectName = coll.getString("object_name");

}

coll.close(); // very important this is done

getIDByQualification just needs the where clause and it will supply the select. If you take a look at the DFC JavaDocs there are some examples and more information about the methods there