SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual523730-004
3-2
Effect. The operation fails.
Recovery. Check that a schema named schema does exist and resubmit.
SQL 1004
Where object-name is the name of an SQL/MX object.
Cause. You attempted an operation on an object that does not exist.
Effect. The operation fails.
Recovery. Check that an object named object-name does exist. If you did not fully
qualify the name, check that the defaults generate the correct fully qualified name and
resubmit.
SQL 1005
Where constraint-name is the name of a column constraint or table constraint.
Cause. The ALTER TABLE statement you attempted requires the existence of a
constraint named constraint-name.
Effect. The operation fails.
Recovery. Check that a constraint named constraint-name exists for the table
specified. You can use the SHOWDDL command to find the names of the constraints
that exist on a table.
SQL 1006
Where index-name is an SQL/MX object name.
Cause. The operation you attempted requires the existence of an index named
index-name.
Effect. The operation fails.
Recovery. Check that an index named index-name does exist. If you did not fully
qualify the name, check that the defaults generate the correct qualified name.
1004 Table, view, or stored procedure object-name does not
exist or object type is invalid for the current operation.
1005 Constraint constraint-name does not exist.
1006 Index index-name does not exist.