MODIFY_APP_DISCOVER_RULE

Modify specified Application Components Discover Rule record.

Table: REDADM.RED_APP_DISCOVER_RULES (Search rules to identify database objects that will be added to an application. The list of objects resulting from the search rules is visible in view REDAM.RED_APP_COMPONENTS.)

Parameter Name	Properties	Default Value	Parameter Description
p_rule_id	(PK)(NN)		Unique ID of a search rule
p_app_name	(NN)		Name of the application as defined in table REDADM.RED_PSA_APPLICATIONS.APP_NAME
p_schema_incl_pattern	(NN)	‘.*’	Regular expression that matches one or more database schema names to be included
p_schema_excl_pattern			Optional regular expression that matches one or more database schema names to be excluded
p_table_incl_pattern	(NN)	‘.*’	Regular expression that matches one or more table names to be included
p_table_excl_pattern			Optional regular expression that matches one or more table names to be excluded
p_bdomain	(NN)		Name of the business domain
p_rule_comment			Comment regarding the search rule

Example

EXECUTE SCRIPT api_redadm.modify_app_discover_rule
            ( 0          -- p_rule_id
            , 'XXX'      -- p_app_name
            , '.*'       -- p_schema_incl_pattern
            , 'XXX'      -- p_schema_excl_pattern
            , '.*'       -- p_table_incl_pattern
            , 'XXX'      -- p_table_excl_pattern
            , 'XXX'      -- p_bdomain
            , 'XXX'      -- p_rule_comment
            );