SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-39
SQL 1247
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Identify the rows that do not satisfy the constraint by issuing a SELECT
statement that contains the negation of the constraint. Delete or modify the identified
rows so that remaining rows satisfy the constraint. Enter the CREATE CONSTRAINT
statement again.
SQL 1248
Cause. The MAXEXTENTS value can be modified only for the last partition of an
entry-sequenced or relative table.
Effect. The statement fails.
Recovery. Correct the statement. For a partitioned table, check that the object name
identifies the last partition. For a nonpartitioned table, remove the PARTONLY clause.
Then, enter the statement again.
SQL 1249
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Create a new table with the correct number of columns that has the same
contents as the old table.
SQL 1250
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Enter the statement again with a KEYTAG value in the range from 1
through 65,535.
1247 The data in the table does not satisfy the constraint.
1248 MAXEXTENTS cannot be altered for an intermediate
partition of an entry-sequenced or relative table.
1249 A column cannot be added to an entry-sequenced table.
1250 KEYTAG 0 is reserved for the primary key of the file.