SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-11
SQL 3038
Cause. The number of characters in the default string for a column exceeds the length
of the column.
Effect. The statement does not compile.
Recovery. Specify a default string that does not exceed the length of the column, and
recompile.
SQL 3039
Cause. You specified a string that exceeds the maximum length allowed for a default
string. For character columns, the default string cannot exceed 8 characters.
Effect. The statement does not compile.
Recovery. Specify a default literal string that does not exceed 8 characters or the
length of the column, whichever is shorter, and recompile.
SQL 3040
Cause. The terminating quotation mark for the literal string is missing.
Effect. The statement does not compile.
Recovery. Add a quotation mark after the string and recompile.
SQL 3041
Cause. You specified a string that was longer than 3000 characters, and the SQL
parser accepts a maximum of 3000 characters for either view text, FIRST KEY values,
or the default string.
Effect. The statement does not compile.
Recovery. Shorten the text of the view definition, shorten the FIRST KEY values, or
shorten the default string and recompile. Note also that for a statement to execute, the
FIRST KEY values cannot exceed the length of the primary key, which has a maximum
of 255 characters.
3038 Literal string length must not exceed column length.
3039 A literal string of up to 8 bytes is allowed.
3040 The statement is missing an ending quotation mark.
3041 String size cannot exceed 3000 characters.