Introduction
Available only for schemas created with AIP Core ≥ 8.3.45.
Properties on links can be either alphanumeric or numeric. To modify the property of a link that already exists in the Analysis schema, two CAST entry tables are used, depending on the type of property:
- Alphanumeric > CI_STR_LINK_PROPERTIES
- Numeric > CI_INT_LINK_PROPERTIES
The examples in this section modify numeric properties, however it is fairly simple to modify the queries if you want to work with alphanumeric properties. To view a list of properties that can be modified, use the CAST System View "CTV_PROPERTIES":
SELECT * FROM <local>.ctv_properties ORDER BY <local.ctv_properties.prop_name
For example:
Adding a new/changing an existing property based on an OBJECT_ID
In this example, we are going to add a new numeric property as follows:
- Line number where the first column of a composite index is not used in a WHERE clause, which is described in the Analysis Service as "nouseoffirstcolofcompidx_table_clientlanguage" and we are going to add the value "L_propertyValue".
The next step is to insert the data into the CAST entry tables that will cause the properties in question to be modified when the tool is run:
insert into <local>.CI_INT_LINK_PROPERTIES (CALLER_GUID, CALLED_GUID, PROP_NAME, VALUE, ERROR_ID) values ('methodCaller', 'methodCalled', 'nouseoffirstcolofcompidx_table_clientlanguage', L_propertyValue, 0);
The 0 parameter will enter 0 in the ERROR_ID column of the tables in question.
Removing an existing property based on an OBJECT_ID
In this example we are going to remove the numeric property we added in the previous example:
insert into <local>.CI_NO_LINK_PROPERTIES (CALLER_GUID, CALLED_GUID, PROP_NAME, ERROR_ID) values ('methodCaller', 'methodCalled', 'nouseoffirstcolofcompidx_table_clientlanguage', 0);
The 0 parameter will enter 0 in the ERROR_ID column of the tables in question.