SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-25
SQL 3099
Cause. The ordinal position of the start field must precede or equal the ordinal position
of the end field. The implied order of the fields is YEAR, MONTH, DAY, HOUR,
MINUTE, SECOND, FRACTION.
Effect. The statement fails.
Recovery. Check the start and end values. One possible solution is to exchange the
start and end fields, if they were specified in reverse order.
SQL 3100
Cause. A column definition cannot include both the NOT NULL clause and a NULL
constant in the DEFAULT clause.
Effect. The statement fails.
Recovery. Either remove the NOT NULL clause or remove the NULL constant from
the DEFAULT clause, and reissue the statement.
SQL 3101
Cause. You specified a heading string that had more than 132 characters.
Effect. The statement fails.
Recovery. Specify a heading string with 132 or fewer characters, and reissue the
statement.
SQL 3102
Cause. You specified a heading string that had more than 77 characters.
Effect. The SQL compilation continues.
Recovery. Informational message only; no corrective action is needed.
3099 The fields are in the wrong order for a DATETIME or
INTERVAL specification.
3100 The DEFAULT NULL clause and the NOT NULL clause cannot
appear in the same column definition.
3101 Heading text cannot exceed 132 characters.
3102 Heading text is more than 77 characters.