¶ 1 Add an application
The script API_REDADM.ADD_APPLICATION can be used to create a new application. To be able to add an application one has to define the name of the application, optionally a description of the application and choose if system table ‘EXA_DBA_DEPENDENCIES_RECURSIVE’ should be used additionally to the ‘RED_APP_DISCOVER_RULES’ table.
¶ Example
EXECUTE SCRIPT API_REDADM.ADD_APPLICATION(
'test_app' -- p_app_name
,'this is a test application' -- p_description
,false -- p_use_deps
);
After successful creation of a new application, it can be found in the table REDADM.RED_APPLICATIONS.
| APP_NAME | DESCRIPTION | USE_DEPS |
|---|---|---|
| test_app | this is a test application | false |
¶ 2 Modify an application
To modify any of the parameters of an application the script API_REDADM.MODIFY_APPLICATION can be used. One has to provide the exact name of the application one wants to change and then provide the new values for those parameters that should be changed. For the parameters that should not be changed one has to provide a 'null' value, as this will keep the already saved value.
In the example below, only the description will be changed.
¶ Example
EXECUTE SCRIPT API_REDADM.MODIFY_APPLICATION(
'test_app' -- p_app_name
,'changing the description' -- p_description
,null -- p_use_deps
);
After the command above has been issued, the entry in the table REDADM.RED_APPLICATIONS will have changed as follows:
| APP_NAME | DESCRIPTION | USE_DEPS |
|---|---|---|
| test_app | changing the description | false |
¶ 3 Remove an application
To remove an application one only has to provide the exact name of the application which should be removed to the script API_REDADM.REMOVE_APPLICATION.
¶ Example
EXECUTE SCRIPT API_REDADM.REMOVE_APPLICATION (
'test_app' -- p_app_name
);
After the example above has been issued, the entry for the application with the name 'test_app' will be removed from the table REDADM.RED_APPLICATIONS.