logo  
Google
 

DB2 SQL-Error: -478

SQLState: 42893

Short Description: DROP OR REVOKE ON OBJECT TYPE CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE IS DEPENDENT ON IT C A A I PROCEDURE REVOKE A CALL I SEQUENCE REVOKE A SQL A SQL A A T SQLCODE SYSADM W SYSADM REVOKE REVOKE S T P R

The requested action cannot be processed because a dependency exists on this type1. type2 is the type of object that has the dependency on the type1 object involved in the DROP or REVOKE. type2 can be one of the following: v FUNCTION v PROCEDURE v TABLE v VIEW v TRIGGER (for the trigger package) v SEQUENCE v CHECK CONSTRAINT (object_name contains the table name) v DEFAULT (object_name contains the table name)DROP If type1 is FUNCTION, the dependencies for DROP might be: v Another function is sourced on this function. v A view uses this function. v A trigger package uses this function. v A table uses this function in a check constraint or user-defined default. v A materialized query table definition uses this function. The dependency might be on one of the generated cast functions for a distinct type. If type1 is DISTINCT TYPE, the dependencies for DROP might be: v A parameter of a function is defined as this distinct type. v A column of a table is defined as this distinct type. v A parameter of a stored procedure is defined as this distinct type. v A sequence is defined with this distinct type as the data type.If type1 is PROCEDURE, the dependencies for DROP might be: v A trigger definition contains a CALL statement with the name of this stored procedure If type1 is SEQUENCE, the dependencies for DROP might be: v An SQL function is defined that references this sequence. v An SQL procedure is defined that references this sequence. v A view definition is defined that references this sequence. v A trigger is defined that references this sequence.REVOKE If type1 is FUNCTION, the dependencies for REVOKE might be: v A function owned by the revokee is sourced on this function. v A view owned by the revokee uses this function. v A trigger package owned by the revokee uses this function. v A table owned by the revokee uses this function in a check constraint or user-defined default. v A materialized query table owned by the revokee uses this function in the definition.If type1 is DISTINCT TYPE, the dependencies for REVOKE might be: v A parameter of a function owned by the revokee is defined as this distinct type.

 <-  BACK TO INDEX