SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-8
SQL 3027
Cause. The supplied SQL identifier, host variable, or parameter name is greater than
30 characters in length.
Effect. The statement does not compile.
Recovery. Shorten the SQL identifier, host variable, or parameter name, and
recompile.
SQL 3028
Cause. An ALTER TABLE ADD COLUMN statement either specifies the NOT NULL
clause and omits the DEFAULT clause, or specifies the NO DEFAULT clause.
Effect. The statement does not compile.
Recovery. Correct the statement by specifying a valid DEFAULT value, and recompile.
The possible DEFAULT values are DEFAULT SYSTEM or DEFAULT literal.
SQL 3029
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the statement by either removing the NOT NULL clause or
including a DEFAULT clause with it, and recompile.
SQL 3030
Cause. A comment string cannot exceed 132 characters.
Effect. The statement does not compile.
Recovery. Specify a shorter comment string and recompile.
3027 SQL identifiers, host variables, and parameter names
cannot exceed 30 characters.
3028 The column requires a default value.
3029 You cannot specify the NOT NULL clause without a DEFAULT
clause when you alter a column of a table.
3030 The comment is too long.