HPE NonStop SQL/MX Error – 1301 NO ACTION referential action for referential-triggered-action clause is not yet supported as specified by ANSI SQL99 standard. To alter the behavior, set an appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.

In this blog post, let’s learn about the error message “1301 NO ACTION referential action for referential-triggered-action clause is not yet supported as specified by ANSI SQL99 standard. To alter the behavior, set an appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1301 NO ACTION referential action for referential-triggered-action clause is not yet supported as specified by ANSI SQL99 standard. To alter the behavior, set an appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.

Reason for the Error

NO ACTION referential action is specified in the referential integrity definition, and the CONTROL QUERY DEFAULT value for REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT is ‘OFF.’

Solution

To alter the behavior of NO ACTION referential action, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default