SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-2
SQL 7004
Cause. The results of the CASE expression have different and incompatible data
types.
Effect. The statement does not compile.
Recovery. Check that the results have compatible data types.
SQL 7005
Cause. You specified character results for the CASE expressions that have conflicting
collating sequences.
Effect. The statement does not compile.
Recovery. Do not use different collations for the results of the CASE expression.
SQL 7006
Cause. An arithmetic expression involving exact numeric values would have produced
a scale greater than this data type can handle internally.
Effect. The statement does not compile.
Recovery. Simplify your arithmetic expression and recompile the statement.
SQL 7007
Cause. Results of the CASE expression have different and incompatible character
sets.
Effect. The statement does not compile.
Recovery. Make sure that the results of the CASE expressions all have the same
character sets.
7004 The results of the CASE expression have incompatible
data types value-1 and value-2.
7005 The results of the CASE expression have incompatible
collations.
7006 The SQL compiler generator detected an arithmetic
overflow because the result scale of an exact numeric
expression is greater than 18.
7007 The results of the CASE expression have incompatible
character sets value-1 and value-2.