Issue while Update DQL on dmc_xfm_adaptor_config object

Ganesh Kuamr

Dear Dctm Folks,

I need your help on resolving the issue in Form Adaptor.

I need to modify the query present in the existing dmc_xfm_adaptor_config object as it is causing an issue.

I got parser error while trying to update the object using below query:

UPDATE dmc_xfm_adaptor_config OBJECTS

SET param_value = 'select emp.attr1 as emp_id from dm_dbo.EMPLOYEE emp where emp.emp_code='${empcode}''

WHERE r_object_id='091e867581771bb1';

The issue is due to presence of $ symbol in the query.

Your inputs and suggestions will be highly important to me!!!!!

Thanks and Regards,

Ganesh Kumar

Find more posts tagged with

Comments

Alvaro_de_Andres

I think the problem are the double single quotes. If you really want to modify that field wouldn't be easier to do that directly on the database?

Alvaro_de_Andres

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility. Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right. Then search for: "Documentum" and select the first result that appears. This will relocate it to the Developer Network space of the Documentum community.

Documentum

For further guidance on engaging with the communities for Documentum and related products, please refer to the

IIG Communities Getting Started Guide.