ADD_MATERIALIZE_OBJECTΒΆ

Add new Object Definition for Materialization.

Table: REDADM.RED_MATERIALIZE_OBJECTS (Internal table used by view REDADM.RED_MATERIALIZE to materialize other views)

Parameter Name

Properties

Default Value

Parameter Description

p_mat_group

(PK)(NN)

Name of the materialization group as defined in table REDADM.RED_MATERIALIZE_GROUPS

p_mat_order

(PK)(NN)

Order of materialization execution

p_mat_base_schema

(NN)

Schema name of the object that should be materialized

p_mat_base_name

(NN)

Name of the object that should be materialized

p_mat_target_schema

(NN)

Schema name of the target object

p_mat_target_name

(NN)

Object name of the target object

p_del_where_clause

delete where clause

p_use_tmp_space

(NN)

FALSE

Example

EXECUTE SCRIPT api_redadm.add_materialize_object
            ( 'XXX'      -- p_mat_group
            , 0          -- p_mat_order
            , 'XXX'      -- p_mat_base_schema
            , 'XXX'      -- p_mat_base_name
            , 'XXX'      -- p_mat_target_schema
            , 'XXX'      -- p_mat_target_name
            , 'XXX'      -- p_del_where_clause
            , FALSE      -- p_use_tmp_space
            );