MODIFY_CT_GROUP¶

Modify specified CT-Group record.

Table: DBIADM.DBI_CT_GROUPS (SQL Statements for checking CT status of various database types)

Parameter Name	Properties	Parameter Description
p_ct_group	(PK)(NN)	CT status group name. See DBI_LOADER_BD.
p_ct_status_sql	(NN)	SQL statement returns 1 row, 3 mandatory columns: CT_STATUS: OK \| NOK, CT_SUBSTATUS, CT_STATUS_DESCRIPTION: Can contain placeholders @COLUMN@, where COLUMN is a column from DBI_LOADER_DETAILS.
p_ct_db_status_sql	(NN)	SQL statement returns 1 row, 3 mandatory columns: CT_STATUS: OK \| NOK, CT_SUBSTATUS, CT_STATUS_DESCRIPTION: Similar to CT_STATUS_SQL, but on database level. Can contain placeholders @COLUMN@, where COLUMN is a column from DBI_LOADER_DETAILS.
p_ct_changes_sql	(NN)	SQL statement returns comma-separated list of tables which have changed since last CDC_CT_MAX_CHANGE_ID in format schema1.table1,schema2.table2 etc. If it contains placeholder @ct_max_change_id_values@ it will be replaced with the following list of values: (values (‘src_schema’,’src_table’,ct_max_change_id),(‘src_schema’,’src_table’,ct_max_change_id)) as x (SRC_SCHEMA, SRC_TABLE, CDC_CT_MAX_CHANGE_ID)
p_description		Description of the CT status group

Example

EXECUTE SCRIPT api_dbiadm.modify_ct_group
            ( 'XXX'      -- p_ct_group
            , 'XXX'      -- p_ct_status_sql
            , 'XXX'      -- p_ct_db_status_sql
            , 'XXX'      -- p_ct_changes_sql
            , 'XXX'      -- p_description
            );