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

Products

• IDMS
• IDMS - Database
• 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. 

Environment

all supported CA IDMS releases

Cause

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

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