EMPTY_PSAΒΆ

Delete all PSA data including all related metadata.

Parameter Name

Properties

Required

Default Value

Parameter Description

p_psa_schema

(PK)(NN)

yes

Schema of requested table to be cleaned up

p_psa_table

(PK)(NN)

yes

Table name to be cleand up. Table could be also a HT table in which case only the HT will be cleaned. In case of the main PSA table the ERR- and HT-tables will be cleaned out as well.

p_bdomain

(optional) set BDomain to be cleaned (if NULL all BDomains will be cleaned out)

Example

EXECUTE SCRIPT api_redadm.empty_psa
            ( 'XXXXXXXXXX'       -- p_psa_schema
            , 'XXXXXXXXXX'       -- p_psa_table
            , 'XXXXXXXXXX'       -- p_bdomain
            );