Query to update the aspect attribute value for a custom object type

Hi All,

I have a custom object type custom_record to which an aspect dmc_prm_physical_proxy is attached. current_location_m is a custom attribute of object type custom_record and current_location_id is an attribute of aspect dmc_prm_physical_proxy. I would like to update the values for attributes current_location_m and current_location_id using DQL query.

I used the below DQL query to update the values, but received an error message.

update custom_record objects set current_location_m='Offsite Storage', set dmc_prm_physical_proxy.current_location_id='0b011cd78010458e' where r_object_id='0b011cd7806fa347'

Error:

Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: update pwc_rms_record objects set current_location_m='Offsite Storage', set dmc_prm_physical_proxy."

Can you please help me out to update the value of aspect attribute using a DQL. Any help is greatly appreciated.

Thanks & Regards,

Umesh

Find more posts tagged with

Comments

Umesh Marripalli

I have sorted this out myself. We cannot update the Aspect attribute values using DQL query. Also, cannot update running the API scripts in 3rd party tools (dqMan, Samson, Repoint etc.).

But, can only update the Aspect attribute values by running the API scripts in DA.

Hope this helps others who are looking for it

DctmDvlpr

If you are able to execute the API scripts through DA, Then it should execute fine in other tools as well. (IAPI, dqMan, Unless they are not supported). Make sure the version of Docbase is compatible with the tools and the username used on login are same between DA and other tools.