SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-43
SQL 1263
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Change the KEYTAG value to avoid duplicate values.
SQL 1264
Cause. The sum of the length of the columns that make up the primary key exceeded
the limit. This limit depends on the object. For a table, the sum of the column lengths of
the columns specified in the PRIMARY KEY clause cannot exceed 255 bytes, or in the
CLUSTERING KEY clause cannot exceed 247 bytes. A primary key resulting from a
CLUSTERING KEY clause includes an 8-byte SYSKEY column.
For a unique index, the sum of the length of the columns declared for the index cannot
exceed 253 bytes. For a nonunique index, the sum of the length of the columns
declared for the index plus the sum of the length of the columns of the primary key of
the underlying table cannot exceed 253 bytes.
For more information, refer to the SQL/MP Reference Manual.
Effect. The statement fails.
Recovery. Remove or shorten columns that make up the primary key or clustering key
to comply with the length limit of the primary key.
SQL 1266
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Use the FILEINFO command to determine whether the table is a catalog
table. If FILEINFO does not identify the table as a catalog table and you know that the
table should be a catalog table, contact your system manager.
1263 Duplicate KEYTAG.
1264 The primary key is value-1 byte(s) too long.
1266 value-1 is not a catalog table.