ADD_PSA_TABLESΒΆ

Add new GPR-PSA Tables.

Table: REDGPR.GPR_PSA_TABLES (This table maps source tables to PSA tables)

Parameter Name

Properties

Default Value

Parameter Description

p_gpr_config_id

(PK)(NN)

Foreign key to the GPR_CONFIG table

p_master_id

Foreign key to the master table, if applicable

p_psa_schema_name

(PK)(NN)

Name of the schema where the PSA table is stored

p_psa_table_name

(PK)(NN)

Name of the PSA table

p_psa_table_is_target

(NN)

Whether the PSA table is a target (Y/N)

Example

EXECUTE SCRIPT api_redgpr.add_psa_tables
            ( 0                 -- p_gpr_config_id
            , 0                 -- p_master_id
            , 'XXX'             -- p_psa_schema_name
            , 'XXX'             -- p_psa_table_name
            , 'XXX'             -- p_psa_table_is_target
            );