SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-23
SQL 4100
Cause. You specified an ALTER... RENAME command, and the system and volume
names of the old name and new name did not match. For example:
ALTER TABLE \SYS1.$A.B.T RENAME \SYS2.$A.B.T
Effect. The statement fails.
Recovery. Correct the error. If the names need to be different, use the SQLCI DUP
command to duplicate the table to a new location, and drop the old table.
SQL 4102
Cause. An SQLCI user specified a RETURNING clause in an INSERT statement. A
RETURNING clause can only be in a SELECT statement that is being prepared.
Effect. The statement does not compile.
Recovery. Remove the RETURNING clause.
SQL 4103
Cause. If you do not specify correlation names for the tables specified in the view
definition, SQL/MP creates correlation names implicitly. For DEFINE names, each
hyphen (-) and caret (^) in the DEFINE name is mapped to an underscore (_) to
produce a valid SQL identifier. In this case, the first character of the DEFINE name
became “_”, which produced an invalid SQL identifier.
Effect. The statement does not compile.
Recovery. Change the DEFINE name.
4100 System name and volume name of the old name, value-1,
and new name, value-2, must be the same.
4102 RETURNING clause is not allowed.
4103 The correlation name value-1 that is derived from value-
2 is invalid. The first character of the correlation name
cannot be an underscore.