SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-57
SQL 1366
Cause. All of the default values specified for the table do not fit in the file label.
Effect. The statement fails.
Recovery. Change some column definitions to reduce the space their definitions
require. Consider using DEFAULT SYSTEM instead of specifying the value because
the SYSTEM default value requires less space. Also, consider reducing the number of
columns in the table.
SQL 1367
Cause. For a character column, the value exceeds the defined length of the column or
8 characters. For a numeric column, the value exceeds the defined length of the
column. For a date-time or INTERVAL column, the length of the literal string inside the
default value, which is enclosed in single or double quotation marks, exceeds 36
characters.
Effect. The statement fails.
Recovery. Change the default value so that it does not exceed the defined length of a
column, and verify that the value for character columns does not exceed 8 characters.
SQL 1368
Cause. The value is not consistent with the data type of the column.
Effect. The statement fails.
Recovery. Change the default value to a value consistent with the data type of the
column.
SQL 1369
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Check the column name in the catalog.
1366 The default value for column value-1 could not fit in
the label because too many default values were specified.
1367 The default value for column value-1 is too large.
1368 The default value for column value-1 is invalid.
1369 Column value-1 of value-2 is not described in catalog
value-3.