MODIFY_TSA_COLUMNΒΆ

Modify a TSA column

Parameter Name

Required

Parameter-Description

p_obj_schema

yes

TSA schema

p_obj_table

yes

TSA table

p_tsa_column_name

yes

TSA column name

p_ordinal_position

no

column ordinal position (NULL value indicates no changes)

p_compare

no

compare column for historization - true/false (NULL value indicates no changes)

p_is_nullable

no

column is nullable - true/false (NULL value indicates no changes)

p_is_internal

no

column is internal - true/false (NULL value indicates no changes)

p_data_type

no

column datatype (NULL value indicates no changes)

Example

EXECUTE SCRIPT api_reppsa.modify_tsa_column
                  ( 'XXXXXXXXXXXXXXXXXXXX'  -- p_obj_schema       (C) NN / maxLength=128
                  , 'XXXXXXXXXXXXXXXXXXXX'  -- p_obj_table        (C) NN / maxLength=128
                  , 'XXXXXXXXXXXXXXXXXXXX'  -- p_tsa_column_name  (C) NN / maxLength=10
                  , 99                      -- p_ordinal_position (N)
                  , false                   -- p_compare          (B)
                  , false                   -- p_is_nullable      (B)
                  , false                   -- p_is_internal      (B)
                  , 'XXXXXXXXXXXXXXXXXXXX'  -- p_data_type        (C)    / maxLength=128
                  )