MODIFY_PSA_COLUMNΒΆ

Modify a PSA column.

Parameter Name

Required

Parameter-Description

p_obj_schema

yes

PSA schema

p_obj_table

yes

PSA table

p_psa_column_name

yes

PSA column name

p_ordinal_position

no

ordinal position (NULL value indicates no changes)

p_show_in_psb

no

show column in PSB views - true/false

p_cre_hash_col

no

create seperate column for hash value in PSA table (true/false, NULL value indicates no changes)

p_pk_sort

no

extra columns in order by for RED_PK calculation

Example

EXECUTE SCRIPT api_reppsa.modify_psa_column
            ( 'XXX'     -- p_obj_schema
            , 'XXX'     -- p_obj_table
            , 'XXX'     -- p_psa_column_name
            , 999       -- p_ordinal_position
            , false     -- p_show_in_psb
            , false     -- p_cre_hash_col
            , 999       -- p_pk_sort
            );