I would like to update an attribute of an object with an SQL based on object instance id. In processes I can set an attribute with a constant value (like status). Is there a way to do this without using GEL scripts?
Updating attributes via direct-SQL is unsupported, whether it is run through GEL or any* other SQL "tool".
If you want to update application data you should be using XOG, which can be called from GEL (or from any other technology that would support a SOAP call ; e.g. Excel VBA).
* technically, anything that can run SQL could update data, GEL is not anything special here apart from the fact we can run that via a Clarity process.
Retrieving data ...