REMOVE_MATERIALIZE_OBJECTΒΆ
Remove specified Object Definition for Materialization record(s).
Table: REDADM.RED_MATERIALIZE_OBJECTS (Internal table used by view REDADM.RED_MATERIALIZE to materialize other views)
Parameter Name |
Properties |
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 |
Example
EXECUTE SCRIPT api_redadm.remove_materialize_object
( 'XXX' -- p_mat_group
, 0 -- p_mat_order
);