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-37
SQL 1148
Where column-name is the SYSKEY column.
Where table-name is the name of the table.
Cause. You tried to create a referential constraint on a table column that is the
SYSKEY, which is not supported.
Effect. The operation fails.
Recovery. Do not use the SYSKEY as part of the referenced key.
SQL 1150
Where table-name is the name of the table.
Cause. When the Partition Overlay Support feature is enabled without setting volume
names (through CQD POS_LOCATIONS) for table partitions to reside on, location
names are generated automatically. However, SQL/MX could not generate the location
names automatically and, because the CQD POS_RAISE_ERROR is set, the table is
not created.
Effect. The operation fails.
Recovery. To correct the error, choose a recovery method:
•
Verify that the disk volumes are available on the current node and retry the
request.
•
Specify the volume names where the partitions need to be created for the given
CREATE TABLE statement through CONTROL QUERY DEFAULT
POS_LOCATIONS, and then retry the request.
•
Do not set the CQD POS_RAISE_ERROR, in which case, a simple table without
partitions is created when the volume names cannot be generated.
1148 System-generated column column-name of base table table-
name cannot appear in a referential integrity constraint
definition.
1150 Table table-name was not created as Partition Overlay
Support could not generate volume names for the partitions to
reside on.