Why do I get ‘MODIFY not allowed’ in ADS?

book

Article ID: 5102

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database CA IDMS - ADS

Issue/Introduction

The ADS compiler rejects a MODIFY statement with message  

“DC159068 OPERATION NOT ALLOWED FOR SPECIFIED RECORD. STMT FLUSHED”

 

for a certain subschema. 

Cause

MODIFY RECORD is not possible with the subschema used in this dialog.

Environment

all supported CA IDMS releases

Resolution

When you get this message you should check if the record is a member of a set that is not defined in the subschema. If the record is a member of a sorted set, chained or index, and the set is not included in the subschema, IDMS will not allow the record to be modified since a MODIFY could change the sort key and require set maintenance.

Additional Information

 

CA IDMS Reference 19.0

 

https://docops.ca.com/ca-idms-ref/19/en/ads-reference/database-access-commands/navigational-dml/modify