SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-6
SQL 7030
Cause. The operand of the CONVERTTIMESTAMP function was not declared to have
a LARGEINT data type with a scale of zero.
Effect. The statement does not compile.
Recovery. Check that the operand is declared with a LARGEINT data type and a
scale of zero.
SQL 7051
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Check that the two character sets are the same.
SQL 7052
Cause. You specified the COLLATE clause for a value that did not have a character
data type.
Effect. The statement does not compile.
Recovery. Remove the COLLATE clause or correct the value.
SQL 7053
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Specify a collation for the source of the CAST function.
7030 The operand of the CONVERTTIMESTAMP function must have a
LARGEINT data type (binary 64) with a scale of zero.
7051 The result character set of the operation and the
character set of the resultant collation are not the same.
7052 The COLLATE clause can be specified only for values
(literals,columns, host variables or expressions) that have a
character data type.
7053 The source of the CAST function must have a user-defined
collation if the target data type is a multibyte data type
with the UPSHIFT attribute.