ADD_MD_PSA_REFSΒΆ

Add new GPR-MD PSA Refs.

Table: REDGPR.GPR_MD_PSA_REFS (This table maps master-detail relationships to PSA tables and columns)

Parameter Name

Properties

Default Value

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_master_table

(NN)

Name of the master table in the PSA layer

p_psa_master_column

(NN)

Name of the master column in the PSA layer

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.add_md_psa_refs
            ( 0                 -- p_gpr_config_id
            , 'XXX'             -- p_psa_schema_name
            , 'XXX'             -- p_psa_master_table
            , 'XXX'             -- p_psa_master_column
            , 'XXX'             -- p_psa_detail_table
            , 'XXX'             -- p_psa_detail_column
            );