Hi urmas,
You can apply the query without DB access.
i.e. you can use the update query in GEL scripting.
Example -
1. create a process from Administration
2. Create custom typescript.
--------------------------------------------------------------------------------------------------------------------------------------
<gel:script xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="jelly:sql" xmlns:xog="http://www.niku.com/xog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<!-- *******************************-->
<!-- Get and Check DB Connection to Clarity -->
<!-- *******************************-->
<core:catch var="errorVar">
<gel:setDataSource dbId="niku" var="dataSource"/>
</core:catch>
<core:choose>
<core:when test="${errorVar == null}">
<sql:query dataSource="${dataSource}" var="dual">select 1 from dual</sql:query>
<!-- <core:if test="${debug}"> -->
<gel:out>Database connection established</gel:out>
<gel:log level="INFO">Database connection established</gel:log>
<!-- </core:if> -->
</core:when>
<core:otherwise>
<gel:log level="ERROR">Database connection NOT established</gel:log>
</core:otherwise>
</core:choose>
<sql:update dataSource="${dataSource}">
update SRM_RESOURCES
set DATE_OF_TERMINATION = to_char(sysdate,'YYYY-MM-DD')
where unique_name = ''
</sql:update>
</gel:script>
---------------------------------------------------------------------------------------------------------------------