DB2 10.5 for Linux, UNIX, and Windows

VALIDATE procedure - Change an invalid routine into a valid routine

The VALIDATE procedure provides the capability to change the state of an invalid routine to valid.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_UTILITY.VALIDATE--(--object_id--)----------------------><

Parameters

object_id
An input argument of type INTEGER that specifies the identifier of the routine to be changed to a valid state. The ROUTINEID column of the SYSCAT.ROUTINES view contains all the routine identifiers.

Authorization

EXECUTE privilege on the DBMS_UTILITY module.