Neoview Messages Manual (R2.2)

SQL 1301
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.
referential-triggered-action
can either be ON DELETE or ON UPDATE.
Cause 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.’
Effect The NO ACTION referential action cannot be defined.
Recovery To alter the behavior of NO ACTION referential action, set the appropriate value
for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
SQL 1302
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.
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 1304
1304 SQL/MX could not obtain the location of the system schema tables.
Cause The HP Neoview platform 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 Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 1305
1305 The specified schema location subvolume is already in use by schema
schema.
subvolume
is the HP Neoview platform subvolume name specified in the LOCATION
clause of the CREATE SCHEMA command.
schema is the ANSI name of an existing schema that already uses subvolume as a
schema subvolume.
Cause In a CREATE SCHEMA command, you specified subvolume in the LOCATION
clause; however, this subvolume is already being used as schema subvolume by schema.
Effect The statement fails unless it includes the optional REUSE clause to allow reuse of the
same schema subvolume name. If the REUSE clause is used, this is a warning message and
the schema is created successfully. The warning can be issued repeatedly for a single CREATE
56 Data Definition Language (DDL) Messages (1000 Through 1999)