REMOVE_MD_PSA_REFSΒΆ
Remove specified GPR-MD PSA Refs record(s).
Table: REDGPR.GPR_MD_PSA_REFS (This table maps master-detail relationships to PSA tables and columns)
Parameter Name |
Properties |
Parameter Description |
---|---|---|
p_gpr_config_id |
(PK)(NN) |
Foreign key to the GPR_CONFIG table |
p_psa_schema_name |
(PK)(NN) |
Name of the schema where the PSA table is stored |
p_psa_detail_table |
(PK)(NN) |
Name of the detail table in the PSA layer |
p_psa_detail_column |
(PK)(NN) |
Name of the detail column in the PSA layer |
Example
EXECUTE SCRIPT api_redgpr.remove_md_psa_refs
( 0 -- p_gpr_config_id
, 'XXX' -- p_psa_schema_name
, 'XXX' -- p_psa_detail_table
, 'XXX' -- p_psa_detail_column
);