Description:
This update statement can lock a field in Clarity. This update statement can be incorporated into a GEL script. Current code is for SQL Server
Solution:

insert into app_niku.odf_locked_attributes
(ID,OBJECT_CODE, ODF_PK,ATTRIBUTE_CODE,CREATED_DATE,CREATED_BY, LAST_UPDATED_DATE,LAST_UPDATED_BY)
values
(app_niku.ODF_LOCKED_ATTRIBUTES_S1.nextval,’task’,object.id,cur2.attribute_code,sysdate,
vn_userid,sysdate,vn_userid);
“Solutions provided by CA Technologies”