ADD_TARGET_PSACOLΒΆ

Add new GPR-Target PSA column.

Table: REDGPR.GPR_TARGET_PSA_COLVAL (Table storing target PSA column values for a given GPR configuration)

Parameter Name

Properties

Default Value

Parameter Description

p_psa_schema_name

(PK)(NN)

The schema name of the target PSA table for this column value

p_psa_table_name

(PK)(NN)

The table name of the target PSA table for this column value

p_column_name

(PK)(NN)

The name of the target PSA table column for this column value

p_target_varchar

The VARCHAR value for the target PSA table column

p_target_number

The INTEGER value for the target PSA table column

p_target_date

The DATE value for the target PSA table column

p_target_timestamp

The TIMESTAMP value for the target PSA table column

p_red_bdate_from

p_red_bdate_to

p_target_val_is_col

(NN)

FALSE

Example

EXECUTE SCRIPT api_redgpr.add_target_psacol
            ( 'XXX'                      -- p_psa_schema_name
            , 'XXX'                      -- p_psa_table_name
            , 'XXX'                      -- p_column_name
            , 'XXX'                      -- p_target_varchar
            , 0                          -- p_target_number
            , '2025-03-10'               -- p_target_date
            , '2025-03-10 12:00:00'      -- p_target_timestamp
            , '2025-03-10'               -- p_red_bdate_from
            , '2025-03-10'               -- p_red_bdate_to
            , FALSE                      -- p_target_val_is_col
            );