SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-13
SQL 7151
Cause. The length of the trim character operand was not 1.
Effect. The statement does not compile.
Recovery. Change the operand so its length equals 1 and reissue the request.
SQL 7152
Cause. You specified character operands for the POSITION or the TRIM function that
have conflicting collating sequences.
Effect. The statement does not compile.
Recovery. Do not use different collations for the two operands.
SQL 7153
Cause. You specified a string function such as CONCATENATE, POSITION, or TRIM
that attempted to concatenate or compare values with data types that belong to
incompatible character sets. For example, you cannot compare a KANJI value to an
UNKNOWN value. The two operands being compared must have the same character
set.
Effect. The statement does not compile.
Recovery. Check that both operands have the same character sets.
SQL 7160
Cause. Each column of a view being created must have a collation. The selection
expression must include a result collation for each column being defined.
Effect. The statement does not compile.
Recovery. Check that the selection expression that corresponds to the new column
specifies a result collation.
7151 The trim character operand of the TRIM operator is not a
character string of length 1.
7152 The two operands of the value-1 function have
incompatible collations.
7153 Operands of the value-1 function have value-2 and value-
3 character sets that are incompatible.
7160 The result collation for the created column value-1 is
undefined.