SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-56
SQL 1302
Where referential-triggered-action can either be ON DELETE or ON
UPDATE.
Cause. NO ACTION referential action is specified in the referential definition and the
CONTROL QUERY DEFAULT value for
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT is ‘SYSTEM.’
Effect. The NO ACTION referential action has RESTRICT referential action
semantics. It is recorded as NO ACTION in the metadata table.
Recovery. To alter the behavior of the NO ACTION referential action, set the
appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
SQL 1303
Where table-name is the ANSI name of an SQL/MP ALIAS, or the Guardian file
name of an SQL/MP table.
Cause. An SQL/MP database object was referenced in a create view or create trigger
operation, which is not allowed.
Effect. The operation fails.
Recovery. Specify only SQL/MX native database objects in create view or create
trigger operations.
SQL 1304
Cause. The Guardian location of the system schema tables could not be obtained
from the anchor file.
Effect. The operation fails. This message will be accompanied by one or more other
messages detailing the reason for the failure.
Recovery. Correct the error, as reported in the accompanying messages, and
resubmit.
1302 NO ACTION referential action for referential-triggered-
action clause behaves like RESTRICT referential action. To
alter the behavior, set the appropriate value for the
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
1303 SQL/MP table or alias name table-name is not allowed in
this context.
1304 SQL/MX could not obtain the location of the system
schema tables.