-575 OBJECT object-name (OBJECT TYPE object-type) CANNOT BE REFERENCED EXPLICITLY OR IMPLICITLY
Explanation
The statement referenced an object, but the object cannot be used as requested.
- object-name
- The name of the referenced object.
- object-type
- The type of object that was referenced. Possible values include:
- VIEW
- An alteration was made to a table that underlies the object-name view, which caused the view definition to become invalid. The view must be successfully regenerated with an ALTER VIEW statement before it can be referenced in a statement other than ALTER VIEW, GRANT, REVOKE, DROP, COMMENT, or LABEL. Issue an ALTER VIEW statement to regenerate the view.
- ROW PERMISSION
- The object-name row permission is invalid because a previous attempt to regenerate it was unsuccessful. The row permission must be disabled before the row access control enforced table can be referenced. To correct the invalid state, the row permission must be dropped and re-created with a modified definition.
- COLUMN MASK
- The object-name column mask is invalid because a previous attempt to regenerate it was unsuccessful. The column mask must be disabled before the column access control enforced table can be referenced. To correct the invalid state, the column mask must be dropped and re-created with a modified definition.
System action
The statement cannot be processed.
Programmer response
Take the suggested corrective action.
SQLSTATE
51024