SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-14
SQL 7170
Cause. You specified a host variable that did not have a numeric data type.
Effect. The statement does not compile.
Recovery. Check the data type of the host variable in the INTO clause.
SQL 7171
Cause. You specified a host variable that did not have a character data type, or the
host variable had a multibyte character set.
Effect. The statement does not compile.
Recovery. Check the data type of the host variable in the INTO clause.
SQL 7180
Cause. The RETURNING clause in an INSERT statement returns the value of a
system-defined primary key for the last record inserted. The host variable that holds
the returning value must have a numeric data type and must be large enough to hold
the value.
The data type of the system-defined key for each file organization is:
INTEGER UNSIGNED for entry-sequenced and relative tables
LARGEINT SIGNED for key-sequenced tables
Effect. The statement does not compile.
Recovery. Declare a numeric host variable for the RETURNING clause.
7170 The data type of the host variable in the INTO clause of
a GET VERSION statement must be numeric.
7171 The host variable in the INTO clause of a GET CATALOG
statement must have a character data type with a single-byte
character set.
7180 The host variable specified in the RETURNING clause must
have a numeric data type.