SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-28
SQL 3112
Cause. You specified a date-time or INTERVAL literal as a default value for a column,
but the value does not have the same precision as the column. That is, the range of
date-time fields, the leading precision, or the fraction precision was different.
Effect. The statement fails.
Recovery. Specify a correct default value for the date-time or INTERVAL column, and
reissue the statement.
SQL 3113
Cause. You specified a numeric literal that was not within the valid range.
Effect. The statement fails.
Recovery. Specify a valid numeric literal and reissue the statement.
SQL 3114
Cause. You might have specified the FOR UPDATE clause in a SELECT statement
that also includes the INTO clause and is not a dynamic SQL statement. You can
specify the FOR UPDATE clause only if you are preparing a SELECT statement or if
the SELECT statement appears in a DECLARE CURSOR statement.
Effect. The statement fails.
Recovery. Remove the FOR UPDATE clause and reissue the statement.
SQL 3115
Cause. You specified a FOR UPDATE clause for the result of a UNION operation.
Effect. The statement fails.
Recovery. Remove the FOR UPDATE clause and reissue the statement.
3112 The default date-time (DATE, TIME, TIMESTAMP, DATETIME)
or INTERVAL value specified for the column must have the same
precision as the column.
3113 Overflow or underflow occurred on numeric literal.
3114 FOR UPDATE clause can only be specified with the SELECT
statement that is being prepared or the SELECT statement
appearing in a DECLARE CURSOR statement.
3115 FOR UPDATE clause cannot be specified on the result of
the UNION.