SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-21
SQL 3078
Cause. SQL/MP expected a column definition or PRIMARY KEY clause, but none was
specified.
Effect. The statement does not compile.
Recovery. Include a column definition or PRIMARY KEY clause, and reissue the
statement.
SQL 3081
Cause. Cause. You specified a scale with the SETSCALE function that is larger than
the size of the variable.
Effect. The statement fails.
Recovery. Specify the correct scale and reissue the statement.
SQL 3082
Cause. You used the SETSCALE function with a nonnumeric host variable.
Effect. The statement fails.
Recovery. Correct the statement and reissue the statement.
SQL 3083
Cause. You specified a USE COLLATION[S] clause on a CREATE TABLE statement
without the LIKE option.
Effect. The statement fails.
Recovery. Remove the USE COLLATION clause or use it with the LIKE option or in a
PARTITION clause, and reissue the statement.
3078 Missing column or key.
3081 The specified scale is more than the maximum allowed.
3082 The SETSCALE function can only be used with host
variables that have numeric data types.
3083 The USE COLLATION[S] clause on a CREATE TABLE statement
can be specified only for the LIKE option or in a PARTITION
clause.