Editable Index field/values in an AppGroup

[mroutlander]

A warm hello to fellow ODUsers,

I need a little help. My client wants to make certain index fields/values modifiable in a particular app group - let's say fields InvNumber and InvAmt in a certain AG called InvoiceUpdate. These should be editable for a certain group only - say ZonalManagerGroup.

While I understand that this process would start somewhere from the AG permissions tab and/or the ARSAGPERMS table. But I am not sure where and how to begin it?

Any assistance will be appreciated. Please let me know if I haven't furnished any other required information.

Warm regards,
Abhinav

Edit: Forgot to mention: this is for CMOD on Multiplatforms v 9.0.0.3

[Alessandro Perucchi]

Hello,

so first don't modify the table ARSAGPERMS :-) even if you could find out how it works, it is not supported by IBM to touch directly with some update sql commands.

That said, in order to be able to modify the index fields, you must ensure the following:

• You have put the fields you want to update with the field type "updateable" (tab 'Field Information' in the AG)
• The users have the permission to update the application group (tab "Permission" in the AG)

Then when both thing are done, then you can let the users change the fields.

Hope that helps.

[mroutlander]

Wow! That was easy 
Thanks a lot, Alessandro!!