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
            );