Enhanced Custom Query is not accepting Update sql statment

[Shravan]

Enhanced Custom Query is failing not accepting udate statment as shown below screenshot and query as we used in customqueryjob

update endpoints ep Inner Join (select distinct ev.displayname,evep.entitlement_value from entitlement_values evep, (select attribute_value,entitlement_value_key,attribute_name from entitlement_value_attrs where attribute_name='BusinessServiceName') eva, entitlement_values ev where evep.ENTITLEMENT_VALUEKEY=eva.entitlement_value_key and ev.customproperty6 = eva.attribute_value and evep.entitlement_value IN ('i-0004fe6a81af22ea2','i-0059df72411d0798b','i-0065cc1c04189bdf4')) ct on ep.endpointname = ct.entitlement_value set ep.customproperty42 = ct.displayname where ep.endpointname = ct.entitlement_value

 @RMJ 

[Saathvik]

@Shravan : New Enhanced Custom Query job will not support INSERT, UPDATE statements, You need to prepare the select query. For example see below

Original Query

update ars_requests set comments = 'comments' where requestkey = 1;

Enhanced Custom Query

select "comments" as ars_requests__comments, requestkey as ars_requests__primaryKey from ars_requests where requestkey = 1;

You can find more details in Saviynt FAQ