REMOVE_PSA_TABLESΒΆ
Remove specified GPR-PSA Tables record(s).
Table: REDGPR.GPR_PSA_TABLES (This table maps source tables to PSA tables)
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_table_name |
(PK)(NN) |
Name of the PSA table |
Example
EXECUTE SCRIPT api_redgpr.remove_psa_tables
( 0 -- p_gpr_config_id
, 'XXX' -- p_psa_schema_name
, 'XXX' -- p_psa_table_name
);