Previous Topic: -269 - FOREIGN KEY LOOPNext Topic: -273 - GRANT AND REVOKE STATEMENTS NOT ALLOWED


-272 - ERROR DURING AUTOMATIC REBINDING OF VIEW authid.viewname

Explanation

You are attempting to reference a view (authid.viewname) which has been invalidated, probably because of a change to a base table on which the view depends. CA Datacom/DB has attempted to automatically rebind the view, but has encountered an error condition.

The SQLSTATE that equates to this SQL return code is 56S11.

User Response

CA Datacom/DB recorded the error which occurred during the attempted rebinding of the view in the Statistics and Diagnostics Area (PXX). Your statement cannot be executed until the error has been corrected so that the view can be successfully rebound.