ADMIN HR object statements

The ADMIN HR object statements ( ADD, DELETE, and UPDATE) perform operations on health report application objects.

ADD object statement

The ADMIN HR ADD object statement adds a new health report application object to an application. The object is added to the application object table, ADBHRO, in the health report database.

Syntax:


1  ADMIN HR
2.1 ADD
2.1 INCLUDE
2.1 EXCLUDE
1 objtype qual.name APPLaname? COMMENTdescription

Option descriptions:

INCLUDE
Specifies that the object is to be included in the application.

Use the INCLUDE option (instead of ADD) for situations where multiple objects were previously excluded by using wildcard characters, and now you want to add one or more of those excluded objects back to the application.

EXCLUDE
Specifies that the object is to be excluded from the application.

Use the EXCLUDE option (instead of ADD) for situations where multiple objects were previously added by using wildcard characters, and now you want to exclude one or more of those objects from the application.

objtype
The object type. Possible values are TABLESPACE, PACKAGE, FUNCTION, PROCEDURE, and SERVICE.
qual.name
The qualified name of the object that you want to add. qual, name, or both can include wildcard characters (*).
APPL aname
Specifies the name of the application to which the object is to be added.
COMMENT description
Specifies an optional description for the object.

DELETE object statement

The ADMIN HR DELETE object statement deletes the application object from the application and table ADBHRO.

Syntax:


1  ADMIN HR DELETE objtype qual.name APPLaname

Option descriptions:

objtype
The object type. Possible values are TABLESPACE, PACKAGE, FUNCTION, PROCEDURE, and SERVICE.
qual.name
The qualified name of the object. qual, name, or both can include wildcard characters (*).
APPL aname
Specifies the name of the application from which the object is to be removed.

UPDATE object statement

The ADMIN HR UPDATE object statement updates the application object description. The description is the only information that can be updated for an application object. If you want to change the application for an object, use the DELETE and ADD statements.

Syntax:


1  ADMIN HR UPDATE objtype qual.name APPLaname? COMMENTdescription

Option descriptions:

objtype
The object type. Possible values are TABLESPACE, PACKAGE, FUNCTION, PROCEDURE, and SERVICE.
qual.name
The qualified name of the object.
APPL aname
Specifies the name of the application to which the object belongs.
COMMENT description
Specifies the new description.