SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-14
SQL 3050
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Remove the [NO] VALID DEF[INITION] attribute from the ALTER VIEW
statement and recompile.
SQL 3051
Cause. An illegal value is specified for the number of blocks.
Effect. The UPDATE STATISTICS statement doesn't get compiled.
Recovery. Correct the value and reissue the statement.
SQL 3052
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. If you require the precision, define the column as SIGNED. Later you can
create a constraint to disallow negative numbers in the column. If you do not require
the precision, declare the column requiring 9 or fewer digits.
SQL 3053
Cause. The column is declared as type DECIMAL SIGNED, but the precision is
greater than 18.
Effect. The statement does not compile.
Recovery. Correct the data declaration for the column, making sure that the precision
does not exceed 18.
3050 [NO] VALID DEF[INITION] attribute is not allowed in the
ALTER VIEW statement.
3051 The number of blocks to be sampled must be in the range
1 to 2147483647.
3052 Unsigned decimal numbers with precision greater than 9
are not allowed.
3053 Signed decimal numbers with precision greater than 18
are not allowed.